Hi,
How to copy filtered records into new worksheet. if i copy the filtered record, hide records are also copied. Please Help!. Thanks in advance
Hi,
How to copy filtered records into new worksheet. if i copy the filtered record, hide records are also copied. Please Help!. Thanks in advance
hi,
To only select visible cells you can select the relevant range, press [F5], "Special" & "Visible Cells only" before copying the records to the next sheet.
A shortcut combination for selecting visible cells only is [alt + :].
hth
Rob
Rob Brockett
Kiwi in the UK
Always learning & the best way to learn is to experience...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks