Hello guys,
Situation is that I have a spreadsheet which has 6 sections split up by page breaks and acts like big sum for 10 or so products. The order is:
Stock left over from previous week* +
Stock delivered this week -
Stock Adjustments =
Total Stock Available for sale for that week -
Total Stock sold this week =
Total Stock left over for next week
*The values here look at the total stock left over from the previous week on a different worksheet.
I have a worksheet for each week. When I create a new week I right click on the tab and copy it, rename the tab and then change the dates. I have to find & replace on the "Stock left over from previous week" so it so it's looking at the previous week.
For example Worksheet named 09.06.2008 looks at Stock Leftover on worksheet 02.06.2008 I then copy worksheet 09.06.2008 and rename it to 16.06.2008.
However the Stock Left over from previous week is still looking to 02.06.2008 so I find and replace to change all references to 02.06.2008 to 09.06.2008 - Hope you're following lol
Now I have to hand this of to someone else to do and have protected the worksheet so none of the formulas used can be erased or deleted etc and I've found you cannot find and replace in a protected worksheet. Can you guys think of a way around this or a better solution? Any help would be hugely appreciated
Situation is that I have a spreadsheet which has 6 sections split up by page breaks and acts like big sum for 10 or so products. The order is:
Stock left over from previous week* +
Stock delivered this week -
Stock Adjustments =
Total Stock Available for sale for that week -
Total Stock sold this week =
Total Stock left over for next week
*The values here look at the total stock left over from the previous week on a different worksheet.
I have a worksheet for each week. When I create a new week I right click on the tab and copy it, rename the tab and then change the dates. I have to find & replace on the "Stock left over from previous week" so it so it's looking at the previous week.
For example Worksheet named 09.06.2008 looks at Stock Leftover on worksheet 02.06.2008 I then copy worksheet 09.06.2008 and rename it to 16.06.2008.
However the Stock Left over from previous week is still looking to 02.06.2008 so I find and replace to change all references to 02.06.2008 to 09.06.2008 - Hope you're following lol
Now I have to hand this of to someone else to do and have protected the worksheet so none of the formulas used can be erased or deleted etc and I've found you cannot find and replace in a protected worksheet. Can you guys think of a way around this or a better solution? Any help would be hugely appreciated