Merg Worksheets

[Mike Bubyn]

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

 

[Bob Umlas]

Have a look in Help at Data/Consolidate
MAY be what you are looking for.

 

[Mike Bubyn]

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.