Hi There,
I have a spreadsheet with 500 rows of data. I need to be able to select a subset of this data based on data in another spreadsheet (which is variable) to update it; and if possible flip this selection.
It is like a filter in which you can paste the desired subset to filter the main spreadsheet.
I have a spreadsheet with 500 rows of data. I need to be able to select a subset of this data based on data in another spreadsheet (which is variable) to update it; and if possible flip this selection.
It is like a filter in which you can paste the desired subset to filter the main spreadsheet.
