Combine 3 of 6 worksheets

T

Tasha

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!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

JOIN 3 Excel 07 worksheets 0
Combining Multilple Worksheets Into One 6
multiple worksheets 1
Worksheets and Workbooks 1
Merging worksheets 1
Combine 7 files then create 1 master 2
Combine Multiple Worksheets 2
combine rows with similar data, but different fields in excel 1

Top