View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] mulji.hafeez@gmail.com is offline
external usenet poster
 
Posts: 13
Default 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