I am new here and hope that I selected the correct category for my question.
So what I need to accomplish is the following:
I have locations and the information on their actual registrations and what their registrations were projected to be. This information is broken down by month.
I need to be able in a table or chart reflect actual against projected registrations. I also need to be able to show the variance between actual and projected. While the attached file is presented in one spreadsheet with a tab for projected registrations and a tab for actual registrations they are technically separate files. The other conundrum I had which I solved by creating a common table is that the name of a location in the Projected data will be slightly different than the name of the location in the actual registration data. So in a common “in memory” table I created a code which is the following
Location Code = [Campus Code]& " - " &[Academic Year]
This allows me to link the tables no matter whether “Albuquerque” is listed as such or reflected as “Albuquerque Center.”