I have a question. I have multiple sheets that feed into a report. The sheets have projects in them with actuals and remainder of year forecast. the data feeds into the report. At the end of the month that months actuals are loaded. Currently, the actuals are loaded on the report and pushed down to the individual sheets. We populate the actuals either by copy and paste or manually keying the amounts on the report. Are there any suggestions as to a way to import the actuals into the report? Just trying to eliminate a step in the process that can result in errors. It will take too long to open each sheet and load the actuals. Thanks in advance for any suggestions.
Help Article Resources
Check out the Formula Handbook template!