Hi!

I have several sheets with different names all one after the other. Such as:

Addison, Gary, Twin Lakes, .... etc

I need to create a macro that will go through each one of those sheets and
copy row 2 down to the last piece of data and paste it in a main sheet, we
can call it "IL". Sometimes row 2 and below will be blank so I need to skip
to the next sheet.

Any ideas?

I'd start with Ron de Bruin's site:
http://msdn.microsoft.com/en-us/library/cc793964.aspx

Schwimms wrote:

Hi!

I have several sheets with different names all one after the other. Such as:

Addison, Gary, Twin Lakes, .... etc

I need to create a macro that will go through each one of those sheets and
copy row 2 down to the last piece of data and paste it in a main sheet, we
can call it "IL". Sometimes row 2 and below will be blank so I need to skip
to the next sheet.

Any ideas?

--

Dave Peterson