macro to select and copy rows only containing data
Do you want a macro?
Record yourself autofiltering for non-blanks and copying to the other sheet.
Gord Dibben MS Excel MVP
On Wed, 8 Oct 2008 20:09:01 -0700, shaz0503
wrote:
All
Have searched various forums and can't seem to find what I need. Is really
simple and I know can be done but...
I need to be able to select all rows containing data and then copy and paste
to new sheet - would like the code that selects these rows only.
TIA
Shaz
|