Joseph Rails
New Member
- Joined
- Dec 8, 2020
- Messages
- 1
- Office Version
-
- 365
- Platform
-
- Windows
Hello,
I have an excel sheet I am trying to build and I ran into a problem. I have an excel sheet that I roll forward every month. When a new month arrives I dump that months data into the file.
Some of the cells will get values from the updated data. However, I only want the current month to get values from new data. I want the others not to change unless it is that month.
There is another complicating factor. Every month there are about 100 values that need to be updated and 1100 that do not. The sheet is already slow from all the other calculations I am doing so I need a not computer intensive way if possible.
Thanks,
Joe
I have an excel sheet I am trying to build and I ran into a problem. I have an excel sheet that I roll forward every month. When a new month arrives I dump that months data into the file.
Some of the cells will get values from the updated data. However, I only want the current month to get values from new data. I want the others not to change unless it is that month.
There is another complicating factor. Every month there are about 100 values that need to be updated and 1100 that do not. The sheet is already slow from all the other calculations I am doing so I need a not computer intensive way if possible.
Thanks,
Joe