Copy and Paste Macro

  • Thread starter Thread starter Schwimms
  • Start date Start date
S

Schwimms

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?
 
Back
Top