Hi,
I would really like help on VBA for the below, i can't seem to find the code anywhere!
It would be so greatly appreciated
1. selecting all rows with data below header when filter has been set
2. pasting a number of rows of data into a new sheet on next available empty line (below already filled rows of data)
when i record i get this, however, the top line doesnt work when i change the core data - could i use something like this - xlCellTypeVisible?
Rows("3:3").Select
Range(Selection, Selection.End(xlDown)).Select
Bookmarks