I have a table with data for last quarter
Months Value
Oct-20 10
Nov-20 20
Dec-20 18
Another table with historic data that I want to grow:
Months Value
Jan-20 10
Feb-20 18
:
:
Oct-20 ---
Nov-20 ---
Dec-20 ----
Every quarter I want to be able to fill the Value for the months of the quarter from the first table using Vlookup. However I don't want to disturb the values for the previous month. Can I write any formula or macro that would leave the older set undisturbed but add the values for the last quarter