I have created a similar thread, but left that one open to any suggestion as the solution.
In this thread, I would be keen to know if false statement can do nothing - for any future reference.
I have created a similar thread, but left that one open to any suggestion as the solution.
In this thread, I would be keen to know if false statement can do nothing - for any future reference.
attached a sample worksheet
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
Hello all,
I am not good with using macros and any possible formula i tried failed, so appreciate your help.
I have a table which automatically refreshes based on my raw data. It has three rows for the 3 months of the last quarter
This table has a volume column which gives me volume for each month.
So it would look like
Month Volume
Oct-20 100
Nov-20 200
Dec-20 500
Now I have this second table with all the historic data
Month Volume
Jan-20 100
Feb-20 200
:
:
Sept- 20 300
I want to be able to append the first table to the second table every quarter. So next quarter when the first table will have the data for jan'21 to mar' 21 - those rows should get automatically added to the historic table.
It's all in the same workbook. Appreciate any workaround / formula/ macro/ VBA.