#1
|
|||
|
|||
[EXCEL 2010] Merging data from three different sheets
I have a program that will update information in my database based off of a template. I have data from three different work books that I would like merged into the template. For example:
I have a data in the workbook titled "Master". This work book contains the bulk of the data. Workbook 2 titled "Update 1" contains some new information. Some of it will update the the Master, and some of the data will be new records entirely. workbook 3 titled "Update 2" is the same. If there is a name in all three work books I would only like to add the new data. if updates 1 and 2 contain a name that is not in master list add that name and all data that is on that sheet. |
#2
|
||||
|
||||
Hi, again, bremen. It's an interesting story :-), but you forgot to say what your actual question is. I take it you started out, and then ran into a problem; but what's the problem, exactly?
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
saving data in excel 2010 from excel 2003 | johnkcalg | Excel | 1 | 02-06-2012 07:33 PM |
creating macro for biffurcation in sheets according to data. | Nirik | Excel Programming | 8 | 05-07-2011 05:11 AM |
How to syncronize data in two different sheets | diegogeid | Excel | 2 | 09-30-2010 12:19 AM |
How do I merge data from one sheet in a workbook out into multiple sheets | nolesca | Excel | 4 | 06-07-2010 08:13 AM |
Mail merging and pulling varying data from Excel | shannag1881 | Mail Merge | 0 | 10-05-2009 08:51 AM |