Excel Workbook Multiple Tab and Sheet Cell Corresponding Progressive Dates

Question

I have an Excel Workbook that has 14 Sheets and need each Sheet to have a cell with a progressive date.  I would like to have a formula to set the first date cell and have the other 13 cells continue in a progressive order from the first cell's date.  I would also like the 14 Tabs to correspond with the date contained in each of the 14 Sheet date cells.

Can someone assist me please?

Thank you.

Answer 1

Hi,

You may refer to my solution - Worksheet formulas in a newly copied worksheet should point to the previous worksheet.

Hope this helps.

Answer 2

How do I do it via VBA?

Answer 3

You are welcome.  I am not clear about the second problem.  If you want the tab name to be picked up from a worksheet cell, you will need to do this via VBA.

Answer 4

Thank you, that part I understand. The part that I am not clear on his how to get the tabs at the bottom of the workbook to reflect the dates in each of the worksheets.

Answer 5

Thank you Ashish. That really helped me solve the first half of my challenge. Now how do I get the tab dates to correspond with each sheet date and self populate when I change the cell in the first sheet that allows the 13 remaining sheets to have a progressive date?