How do I concatenate 2 lists and their data into a macro?
Hi, I'm hoping someone could help. I'll explain what I'm trying to achieve and then what I've tried below that.
I have Sheet1 with 2 account columns and actuals data in column 3. I want to bring in the forecast and budget data from Sheet2, however there may be additional combinations in sheet 2 that don't exist on sheet1.
Sheet 2 will have Fcst and Budget data against the same and additional account combinations. Account 200000 from Sheet 1 doesn' t exist and the last 2 lines are new combinations that don't exist in Sheet 1.
I've been trying to solve this problem with vlookup and index formulas without much joy. So I can look up the account combinations with a sumif and compare, but can't figure out how to add the new ones. I can identify new combinations in both sheets with a vlookup, but struggle to combine into one list and bring the values into one sheet. As I need to do this regularly, this would be best suited to a macro. Any help?
Re: How do I concatenate 2 lists and their data into a macro?
One possible approach attached -- uses a 3rd tab to consolidate the Actuals & Forecast/Budget data, and would account for duplicate entries (presumed unlikely given nature of data, but catered for regardless). There will be much slicker ways of doing it, for sure.