I have a spreadsheet with thousands of rows which is currently filtered to hide duplicate rows.
I now wish to copy a large set of data into a column when it is already filtered and for the values to be updated in the visible cells when filtered (so that when I remove filters), only a selection of the cells in that column contain values).
At present, when I paste the data, it pastes into a range such as A2:A750 even if the majority of those cells are currently hidden/filtered.
Please could anyone advise what I need to set in order to only paste range into filtered cells only?
Thanks in advance.
Bookmarks