I have a spreadsheet that calculates the costs for a student for 2 semesters and prints a one page report. I have set the worksheet to compare the start date of the semester with an effective date. If semester-start-date < effective-date, then I use costs from the current-costs page. If semester-start-date > effective- date, then I use costs from the next-costs page. Each of the costs pages is about 15 rows by 6 columns.
Costs are updated every 1-3 months, not necessarily at a month end. At 'effective-date' I want to delete the page current-costs, rename 'next-costs' to 'current-costs', and create a new 'next-costs' page. When I rename 'next-costs' to 'current-costs' it changes the references in the first spreadsheet. Is there a way to do 'absolutes' on a VLOOKUP page reference like on a cell reference (i.e. $b$17)