Thanks for that - but I don't think I explained myself properly

I have a worksheet that contains raw data - as the number of rows of data
changes monthly I need to be able to select all rows with data only and then
I can continue with my formatting etc.

the macro I am thinking of pretty mch goes down all rows til the next blank
row and then copies all rows 'up'... hope this is a little clearer

TIA

Shaz

"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