Any ideas...
I have a massive spreadsheet with lots of column headings.
I want to copy only certain columns of data based on given criteria from one columns. E.g. one column has request fields, so firstly I wan to filter on these fields to only show 3 out 10.
then based on everything that is now filtered I want to copy the data in column 1, 2, 3, 6 and 8
Does anyone know if this is possible?
Bookmarks