1.

Solve : Help Appreciated on MS Excel.?

Answer»

I need to create an EXCEL spreadsheet with a Sheet for every month of the year.
(I can do that!)
What I am struggling with is how to create a "sub-sheet" within each months work-sheet for every day of each month.

I hope to be able to have 12 work-sheets, each of them having upto 31 "sub-sheets", each of which can be individually edited with that days usage data.

Can anyone offer a solution to this?

Thank you.Well, a sheet is a sheet.  There's no such thing as a "sub-sheet", or sheet inside a sheet.

I suggest you consider other techniques.  One might be to name ranges in your sheets, creating a RANGE for each day of the month.  If you go through this range NAMING PROCESS for a whole month in one sheet, you can copy that to other sheets.



Discussion

No Comment Found