Hi all,
I am making a main page to do analysis. Under each month category I have a Acutual, Budget, and Variance colum,
Jan. Feb
Actual Budget Variance Actual Budget Variance
x x x x x x
The Budget values are coming from another WS where there are no columns between the months. What I am trying to do is be able to reference the Jan and Feb values on Main tab from the Reference tab, and be able to click and drag to fill in the 180 months.
Attached is an examble that should provide a clearer explanation.
Example.1.xlsx
Thanks for any input.
Bookmarks