Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Generating New Worksheets Every Month
Hi,
So I keep track of daily activities in a worksheet on a monthly basis. I wanted to know if in excel I could have it generate a new worksheet at the beginning of the new month and maybe restrict access to the previous months? Also I have a few formulas feeding other workbooks would it be possible to have the formulas carry over but offset them so that the new months values would be in the column next to the previous months? Thanks in advance |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Generating New Worksheets Every Month
You can lock all the cells on the previous month's worksheet. Then you can
protect that worksheet. In xl2003 menus: Select all the cells format|cells|protection tab|check locked Then Tools|Protection|protect sheet tab give it a memorable password Be aware that this worksheet protection is easily broken by anyone who really wants to. ==== If you have formulas in other workbooks that point at a specific sheet, you'll have to adjust them (Edit|Replace????). One suggestion that may work for you. Name the current month's worksheet: Current Then when you're done with that month, you can rename it to the previous month's name--do this with all the other receiving workbooks closed--so they don't adjust the formula. Then use Current for the new worksheet. wrote: Hi, So I keep track of daily activities in a worksheet on a monthly basis. I wanted to know if in excel I could have it generate a new worksheet at the beginning of the new month and maybe restrict access to the previous months? Also I have a few formulas feeding other workbooks would it be possible to have the formulas carry over but offset them so that the new months values would be in the column next to the previous months? Thanks in advance -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Generating New Worksheets Every Month
On Oct 1, 8:43*am, Dave Peterson wrote:
You can lock all the cells on the previous month's worksheet. *Then you can protect that worksheet. In xl2003 menus: Select all the cells format|cells|protection tab|check locked Then Tools|Protection|protect sheet tab give it a memorable password Be aware that this worksheet protection is easily broken by anyone who really wants to. ==== If you have formulas in other workbooks that point at a specific sheet, you'll have to adjust them (Edit|Replace????). One suggestion that may work for you. Name the current month's worksheet: *Current Then when you're done with that month, you can rename it to the previous month's name--do this with all the other receiving workbooks closed--so they don't adjust the formula. Then use Current for the new worksheet. wrote: Hi, So I keep track of daily activities in a worksheet on a monthly basis. I wanted to know if in excel I could have it generate a new worksheet at the beginning of the new month and maybe restrict access to the previous months? Also I have a few formulas feeding other workbooks would it be possible to have the formulas carry over but offset them so that the new months values would be in the column next to the previous months? Thanks in advance -- Dave Peterson Thanks for the help Dave, it was very helpful. And your suggestion was great it seems to work quite well. Thanks again. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Opening up named worksheets according to the day of the month | Excel Discussion (Misc queries) | |||
Generating business days in a calendar month, EXCLUDING holidays | Excel Worksheet Functions | |||
Generating business days in a calendar month, EXCLUDING holidays | Excel Worksheet Functions | |||
Generating a blank worksheet at the start of the month | New Users to Excel | |||
How to protect and unprotect 30 worksheets in a file every month . | Excel Worksheet Functions |