Previous Topic Next Topic

How to merge the data from 2 different sheets into 1?

Closed
gcaorsiw Posts 2 Registration date Thursday January 29, 2015 Status Member Last seen January 30, 2015 - Jan 29, 2015 at 10:55 AM
RayH Posts 122 Registration date Tuesday August 31, 2010 Status Contributor Last seen June 20, 2016 - Jan 30, 2015 at 10:53 AM
I currently have 2 spreadsheets which show payments from 2 different companies. I'd like to be able to merge them into one spreadsheet which updates itself and adds the new data every time a new entry is made to either one of the 2 base sheets.

So pretty much:

"f_clc_2014" is the first sheet
"f_vina_2014" is the second one
"combined" would be the merged sheet

Is this too complicated to do with formulas? Or is there a way to do it with a dynamic table?
Related:

1 response

Answer 1 / 1
RayH Posts 122 Registration date Tuesday August 31, 2010 Status Contributor Last seen June 20, 2016 26
Jan 29, 2015 at 03:42 PM
Take look at this question and answer and see if you can adapt it for your needs:

https://ccm.net/forum/affich-790722-excel-merge-several-worksheets-into-a-single-one-thanks
1
gcaorsiw Posts 2 Registration date Thursday January 29, 2015 Status Member Last seen January 30, 2015
Jan 30, 2015 at 08:20 AM
Yeah that merges the spreadsheets like I want it to, but it doesn't create a new row everytime I put a new entry in one of the other spreadsheets, which is basically what I need. I'm not too familiarized with macros yet, is there a way for it to be "constantly executing" itself? Or how do I execute it each time I want to update the merged sheet?
0
RayH Posts 122 Registration date Tuesday August 31, 2010 Status Contributor Last seen June 20, 2016 26 > gcaorsiw Posts 2 Registration date Thursday January 29, 2015 Status Member Last seen January 30, 2015
Jan 30, 2015 at 10:53 AM
The difficulty with doing this one row at a time is determining whether or not the change to the sheet is an ADD or a CHANGE of an existing row.
It is far easier to recreate the merge sheet when ever you need it to be updated.

You can run this in a number of ways.
1. Run it manually from the VBA Editor -Alt-F11
2. Add the macro to the Quick Access bar at the top of Excel.
3. Run it from the Macros box - Alt-F8
4. Add a Command button to the sheet and assign the macro to it.
0