I am not sure if this is a Macro or even possible in google sheets. In my sheet I have numerous rows of information with one column with a quantity, at some point i give the cell with the quantity a background fill color of yellow. Not the whole column just certain cells. Is there anyway to automate the process of taking that entire row that has the highlighted cell and move it to another sheet in google sheets? Ultimately deleting it off the original sheet? Hope I made sense.
Bookmarks