|
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.
|