Combine 3 of 6 worksheets
 

I have 6 worksheets in a workbook, I want to take 3 of them and copy all data
but the column headers into a 'combined' worksheet. All sheets have the same
column headers. I am currently highlighting all data in each seperate sheet
and copy/paste 'ing them into the 'combined' worksheet. Is there a macro
that would do this for me? On all sheets columns A-L have data, there may be
some blanks within the columns. I want to copy sheets E,I,O and OEE to sheet
'combined' with no blank rows in between the data copied. Would be so
appreciative if someone could help me with this. It doesn't take a lot of
time to do, but when I'm doing it every month, adds up.

Thanks!!

Combine 3 of 6 worksheets
 

Start here
http://www.rondebruin.nl/copy2.htm

See also the Tips section below the first macro

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm




"Tasha" wrote in message ...
I have 6 worksheets in a workbook, I want to take 3 of them and copy all data
but the column headers into a 'combined' worksheet. All sheets have the same
column headers. I am currently highlighting all data in each seperate sheet
and copy/paste 'ing them into the 'combined' worksheet. Is there a macro
that would do this for me? On all sheets columns A-L have data, there may be
some blanks within the columns. I want to copy sheets E,I,O and OEE to sheet
'combined' with no blank rows in between the data copied. Would be so
appreciative if someone could help me with this. It doesn't take a lot of
time to do, but when I'm doing it every month, adds up.

Thanks!!