I have a summary worksheet that references the current month's worksheet. The summary worksheet takes the current project codes from this month and displays them so faculty members can insert a forecast of hours per project code. When a new project code is added on the current month's worksheet, the summary page's project codes are updated; however, the forecasted hours that were put in by the faculty (static data) does not move in accordance with the project codes. Is there a function or combination of functions that could help me keep the static data assigned to each project code?
Bookmarks