Phil wrote...
Can anyone pls advise how to copy filtered cells to the same
corresponding rows under another column, without over-writing
the original invisible contents. I have chosen GoTo -> Special ->
Visible Cells Only, but it paste in consecutive rows.
This is, unfortunately, how Paste works. I suppose it's possible for
macro to do this, but there's a relatively simple way to do what yo
want without macros.
You coukd add 2 columns to your list. The first would contain origina
row number, entering =ROW() in a cell for each record, then usin
Paste Special to convert those formulas to values. The other colum
you'd use after you'd filtered the list. Enter 1 (or anything else) i
the column to the right of the row number column for all the filtere
records. Then unfilter the table (show all records) and sort it on thi
last column fisrt in ascending order then on the row number column i
ascending order. The filtered records should now appear in consecutiv
rows at the top of the list. Paste into them. Then resort the list o
the row number column only in ascending order. It's kludgy, but i
avoids VBA
