sheet2 references sheet1 problem
Posted by Richie on November 27, 2001 6:22 AM
Sheet1 tracks daily sales in column F with weekly totals every 7 days.
Sheet2 is emailed to my corporation with 1 week's worth of sales and a total.
Sheet2 references sheet1 okay, but I have to change each cell reference manually for all 7 days every week to keep the sales current on sheet2.
Is there a way that the sheet2 cell references (to sheet1) can auto change every week?
I afraid this is as clear as mud!
Thanks for any help!