Google Sheets: copy only filter / filter fields.

Question

I have two sheets, Contacts and Mailer

Visible cells from contacts: Column B after filtering / viewing the filter in the Google spreadsheet must be copied to column A Mailer.

Since there is no public function for the getvisibility string yet, how do I do this? I do not want to write a lot of FILTER () codes, because the filters can continue to change, they will be defined by the user ... the results will always be in column B.

Please let me know about solutions / workarounds.

Worst case scenario: until the row visibility function is open, we will have to manually copy cells from one sheet to another, but I hope to avoid this :)

thanks

Answer 1

You do not need to switch to Excel. Just select and copy the data from the filtered page, go to the new page, select the cell where you want to copy the data, right-click in the cell and choose Paste Special> Paste Only Values.

Answer 2

I had the same question, and here is what I finally did. If you copy the filtered data, you can paste it into Excel, and only visible cells will be inserted. Then I copied this data and pasted it into my Google leaflet. We should not do this, but this is not a bad decision.

Hooray!

Answer 3

When you open a new tab, when inserting, only filtered rows are inserted, you do not need to "Insert only values." Of course, first I will 'copy' the filtered range.