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

Report
Posts
2
Registration date
Thursday January 29, 2015
Status
Member
Last seen
January 30, 2015
-
RayH
Posts
122
Registration date
Tuesday August 31, 2010
Status
Contributor
Last seen
June 20, 2016
-
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?

1 reply

Posts
122
Registration date
Tuesday August 31, 2010
Status
Contributor
Last seen
June 20, 2016
24
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
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 4072 users have said thank you to us this month

gcaorsiw
Posts
2
Registration date
Thursday January 29, 2015
Status
Member
Last seen
January 30, 2015

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?
RayH
Posts
122
Registration date
Tuesday August 31, 2010
Status
Contributor
Last seen
June 20, 2016
24 > gcaorsiw
Posts
2
Registration date
Thursday January 29, 2015
Status
Member
Last seen
January 30, 2015

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.