Project Description:
Data for our property forecasts are downloaded into an excel spreadsheet and then summarized into a pivot table for display purposes.
Forecasts are update monthly.
I would like the users to be able to update the DATA values (non summarized values only) so that the underlying source values are updated.
By way of example I would like the user to be able to change the 'Occupancy %' value on the tab 'Occupancy' and it would update the corresponding value on the 'Raw Data' tab in Column C