| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Merg Worksheets
I am trying to merg worksheets so that the columns in each sheet are compared
to the master sheet, any new columns are added to the master sheet. Is this possible? Ex. Master sheet has columns... A B C D E Sales and Marketing has... A C D E Master still shows columns... A B C D E Finance has columns.... A C D F G H Master now has columns... A B C D E F G H Operations has columns... A C I J Master now shows columns.... A B C D E F G H I J Will I be able to do this...Any help is appreciated, Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Merg Worksheets
Have a look in Help at Data/Consolidate
MAY be what you are looking for. "Mike Bubyn" wrote in message ... I am trying to merg worksheets so that the columns in each sheet are compared to the master sheet, any new columns are added to the master sheet. Is this possible? Ex. Master sheet has columns... A B C D E Sales and Marketing has... A C D E Master still shows columns... A B C D E Finance has columns.... A C D F G H Master now has columns... A B C D E F G H Operations has columns... A C I J Master now shows columns.... A B C D E F G H I J Will I be able to do this...Any help is appreciated, Thanks |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Merg Worksheets
Thanks for the input Bob, I have been through most of it but maybe I missed
something. I didn't think it was going to be this tough! Mike. "Bob Umlas" wrote: Have a look in Help at Data/Consolidate MAY be what you are looking for. "Mike Bubyn" wrote in message ... I am trying to merg worksheets so that the columns in each sheet are compared to the master sheet, any new columns are added to the master sheet. Is this possible? Ex. Master sheet has columns... A B C D E Sales and Marketing has... A C D E Master still shows columns... A B C D E Finance has columns.... A C D F G H Master now has columns... A B C D E F G H Operations has columns... A C I J Master now shows columns.... A B C D E F G H I J Will I be able to do this...Any help is appreciated, Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Print order of worksheets | Excel Discussion (Misc queries) | |||
| Changing a Link Mid-way Across Worksheets | Excel Worksheet Functions | |||
| Define list of worksheets | Excel Worksheet Functions | |||
| Merge Worksheets | Excel Worksheet Functions | |||
| HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) | |||
Hybrid Mode
