Formula to autopopulate date within a spreadsheet and also name each sheet with the date
Hi everyone, I'm trying to create a monthly workbook. Most of the formula is written but I need some help with a part that I'm stuck on. It's a monthly workbook so I want each sheet/tab to represent each day a month and I also want the date to be within the workbook and autopopulate when a new tab is created.
Also, is there a formula where it will automatically read the previous sheet without me having to manually reference the previous sheet.
Autopopulating the date as the sheet name can be done with a macro; not so sure about a formula
Liked the answer given? click * to say so
thank you for replying, I figured that part out. Just trying to figure out how to reference certain cells that have formulas without having to type the formula for each sheet (basically I need to reference a cell in a previous sheet)
Define a name for the cell you want to refeence. That will save you the trouble of having to type the sheet name if you want to refer to it in another place of the workbook
well my workbook has 31 sheets..(1 for each day of the month of Dec) I need each sheet to reference a cell in the previous sheet
I am sorry, I am afraid I can't help much there
Which cell do you want to reference?
Also, give me about 4 or 5 of the sheet names.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks