Apr 10, 2021 ... I am trying use a formula that will take across an entire row from the input sheet to the main sheet if Column E on that row contains the word "NEW".
Jan 28, 2021 ... I am trying to copy a whole row (from column A to O) from Sheet 1 to Sheet 2. It should only do so if column N in Sheet 1 contains a specific word.
Nov 9, 2022 ... I want to be able to search for a word like "Real" or "law" and copy the entire row of all the results into sheet 2. The work could be found in any column.
Jul 13, 2019 ... I am trying to create a practice log for my piano practice. I want the specific text in column D to copy over to column F if column E has "N" in a cell.
Oct 12, 2022 ... I want to automatically copy a row from one sheet to another if column D contains a specific name and column J contains part of text in the cell.
Mar 29, 2022 ... ... copy, only the text.. HELP? I am struggling to find a solution to an issue I have encountered using Google Sheets/Excel. I have linked ...
Feb 29, 2024 ... I am fairly new to Google Sheets and have been struggling with creating a formula for my problem: Sheet 2 Col A has the characters that I ...
Mar 8, 2021 ... I have a google sheet containing about 6000 unique cells. Most ... I know I can go through every cell and copy and paste the text, but ...
May 8, 2020 ... You can do that to link only certain portions of text within the cell or have multiple links for multiple portions of text. Google user.
Apr 30, 2019 ... Normally when you copy a cell with a formula or drag a formula ... specific cell. To follow a specific address you could use INDIRECT ...
Oct 29, 2019 ... At one point not too long ago I was able to set an automatic text format in my sheet for certain columns. So when I copy and paste text that ...
Jul 8, 2020 ... I am trying to use this formula to provide a filtered list of data A1 to C5 that doesn't contain the text "Cert" anywhere in the C column cells.
Feb 5, 2021 ... I have a word document that has several words/areas on it that are linked to cells on a specific excel sheet. I am wanting to transfer both the ...
Dec 17, 2020 ... (click USE TEMPLATE to create a copy for your own use). The sheet uses this formula in C3, copied down: =IF(A3="Complete",IF(Len(B3)=0,NOW ...
Jun 10, 2020 ... at a specific moment (e.g. by checking a box) into another cell. ... copied to F3 as text. Is it possible to flexibilize the getRange ...
Jul 28, 2020 ... ... paste a cell to another place on sheet? In some case I need to mark certain numbers and words with certain colors (text, not the cell itself) ...
Mar 17, 2020 ... Today, when I did my usual copy and paste of formatted cells/data from Excel and into Google Sheets, the formatting reset to the default (Arial, ...
Jun 17, 2019 ... ... cells that contain a fill color. I want those cells to be pasted into a new worksheet and to form their own column. ... text/background color ...