I am struggling to figure out a way to copy filtered contents from 1 spreadsheet to another.
I have 2 spreadsheets, filtered by Modified Date.
Both now shows filtered contents with some hidden rows.
I want to copy all the content from the old spreadsheet to the new spreadsheet.
When I attempt to copy multiple rows, I seems not able to this because some of the rows are hidden.
Please advise how this is done?