Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Merge Workbooks | Excel Discussion (Misc queries) | |||
merge workbooks | Excel Worksheet Functions | |||
Trying to Merge 2 Workbooks | Excel Discussion (Misc queries) | |||
merge workbooks | Excel Worksheet Functions | |||
I'm trying to merge 2 workbooks into 1 new workbook. | Excel Discussion (Misc queries) |