Hi All,
I have an excel sheet where I am planning to summarize the forecasting results for next 6 months.
For example, I have a forecast sheet where I have forecasted for next 6 months. Like
for Jan, my forecast data is from D11 to I11.
And for feb it is from E12 to J12
And for March it is from F13 to K13 and so on
In the summary sheet, I have listed all 12 months in diff columns. I am planning to have 12 buttons based on the months they forecast. Once the click the button the corresponding 6 cells (in the same row) should be referenced in the summary sheet. Is it possible to code efficiently, rather than referencing them directly for each diff cells.
Thank you.
Bookmarks