Hi everyone,
I'd like to explain what this table needs to provide.
We have the monthly revenues by product, but the billing time for that revenue is a number of months away.
How many months, depends on the product.
So, what I need is for example move January revenue of Product A (let's assume Product A's billing time is 2 months) to March column in the table above.
I've attached a screenshot, the gray table needs to be filled. Billing cycles are on the right.
If only there was a =MOVE function that can easily do that.
Could anybody please help? If you need to use a macro for this, could you also give some directions on how to use it.
Thank you!
Capture.jpg
Bookmarks