I had similar post a couple days ago but the solution required using "Indirect" which won;t work because of the various ways the final doc is shared. I've pulled the data from the other document into the one I'll be sharing and here's how I need help now.
I’m setting up an analytic report for next year
H8 represents January
I8 represents February
J8 represents March
K8 represents April and so on through out the year.
My destination cell for the first quarter is W8. In the month of January, W8 will be empty. On Feb 1st, W8 should reflect the number in H8 (January). On March 1st, it should reflect the number in I8 (February) and on April 1st, it should reflect the number in J8 (March). It should remain this way forever.
I have a similar concept for cell Z8.May 1st, it should reflect K8 (April) and continue until July 1st, when it reflects M8 (June) and stays that way forever. Likewise for the remaining months of the year, but if I get Jan – March figured out, I can take it from there.
Thanks in advance.
I’m setting up an analytic report for next year
H8 represents January
I8 represents February
J8 represents March
K8 represents April and so on through out the year.
My destination cell for the first quarter is W8. In the month of January, W8 will be empty. On Feb 1st, W8 should reflect the number in H8 (January). On March 1st, it should reflect the number in I8 (February) and on April 1st, it should reflect the number in J8 (March). It should remain this way forever.
I have a similar concept for cell Z8.May 1st, it should reflect K8 (April) and continue until July 1st, when it reflects M8 (June) and stays that way forever. Likewise for the remaining months of the year, but if I get Jan – March figured out, I can take it from there.
Thanks in advance.