hey everyone.
my problem is this....
i have a sheet in a workbook looking up data on another sheet called "this week". but the following week i want to change the "this week" sheet to have the title as the week no. (11), and create a new "this week" sheet. The problem is that the sheet with the lookups now looks up the data in the "11" sheet instead of the "this week" sheet. Is there any way to make the lookup sheet static, the way you can make a cell reference static with the $ symbol?
my problem is this....
i have a sheet in a workbook looking up data on another sheet called "this week". but the following week i want to change the "this week" sheet to have the title as the week no. (11), and create a new "this week" sheet. The problem is that the sheet with the lookups now looks up the data in the "11" sheet instead of the "this week" sheet. Is there any way to make the lookup sheet static, the way you can make a cell reference static with the $ symbol?