#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 82
Default Merge workbooks

Hello,
I would like to know if merging workbooks is what I need to do.

My boss has a workbook he has added columns and rows to. Occasionally
someone in the company will send him an updated workbook, but their updated
workbook does not have the added columns and rows to it. He would like me to
figure out if we can merge the two of them without messing up his added
columns and rows.
Is this possible? Or do we want to try something else? And if it is merging
workbooks we want, what is the easiest way?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,856
Default Merge workbooks

If by "merging" you mean you want to add the data from a newer
workbook to what you already have, then you will just need to insert
the relevant columns in the newer book and then copy/paste the data
across.

If, however, you mean that you want to affect the values that your
boss has in his file then you could probably do it using VLOOKUP - you
will need to provide more details of the layout of both files and what
you want to do with them, though, if you want more detailed help.

Pete

On Oct 29, 10:21 pm, Bonnie wrote:
Hello,
I would like to know if merging workbooks is what I need to do.

My boss has a workbook he has added columns and rows to. Occasionally
someone in the company will send him an updated workbook, but their updated
workbook does not have the added columns and rows to it. He would like me to
figure out if we can merge the two of them without messing up his added
columns and rows.
Is this possible? Or do we want to try something else? And if it is merging
workbooks we want, what is the easiest way?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Merge Workbooks clara Excel Discussion (Misc queries) 1 April 10th 07 12:26 PM
merge workbooks FYF Excel Worksheet Functions 2 December 13th 06 07:50 PM
Trying to Merge 2 Workbooks Anne Excel Discussion (Misc queries) 2 July 18th 06 09:28 PM
merge workbooks mg_sv_r Excel Worksheet Functions 1 June 14th 06 06:16 PM
I'm trying to merge 2 workbooks into 1 new workbook. Barb Excel Discussion (Misc queries) 0 September 23rd 05 03:42 PM


All times are GMT +1. The time now is 05:45 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"