View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Tasha Tasha is offline
external usenet poster
 
Posts: 157
Default 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!!