This sheet is a simplified example of what I'm trying to accomplish. The files are for forecasting and each month when the report runs updated Store Counts and Unit Movement information will be populated into the data tab. When I know that a future months Store Count or Unit Movement will change I want to be able to hardcode the expected value to use for forecasting purposes.
However, when I start to forecast the next month I do not want to have to redo the work I did from the prior month in terms of the hardcoded values I entered. I need a way to transfer only the hardcoded values to the new spreadsheet. However, the issue is that the new spreadsheet may contain new items so the row that a item is on could change from month to month. I need to get the hard coded values onto the correct row and the correct month.
I posted two files, Original_Forecast_Sheet which is where I will do forecasting work including hard coding certain values that I know will be changing for future months.
The Updated_Forecast_Sheet will be the new spreadsheet that I download each new month, I want to be able to get all of the hardcoded values from the prior month into the correct row and month of the Updated_Forecast_Sheet
My forecast files will have hundreds of items so I need an automated way of transferring the hardcoded values to the Updated_Forecast_Sheet. As a bonus it would be nice to show which cells are hardcoded, maybe by a different cell color.
Thank you in advance