Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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!! |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I combine worksheets w/o enough rows to combine? | Excel Worksheet Functions | |||
Trying to combine 2 Worksheets | Excel Discussion (Misc queries) | |||
How do I combine worksheets | Excel Worksheet Functions | |||
Combine Worksheets | Excel Worksheet Functions | |||
How to combine several worksheets | Setting up and Configuration of Excel |