Excel Help

[JBW1366]

Hi, I need to set up an excel spreadsheet - with a tab for everyday day of a working week - which I use as a diary.. and the current day is deleted the next day.

Is there a way, of setting up this automatically, because currently I copy and paste.

Others would like to use this system, is there an easy way for a technophobe?

Thanks in advance

[bookbinder]

https://www.supportyourtech.com/excel/how-to-make-an-excel-spreadsheet-a-step-by-step-guide-for-beginners/

[JBW1366]

I did like an identical worksheet on each tab with the date as the tab name, and for excel to create this automatically? Is this possible? 

[newmodarmy]

How many tabs do you need- 7 for the days in a week or 365 for a year?

If it's a manageable number it's easy to copy the same spreadsheet from one tab to another- just click the little triangle to the left of cell A1 to highlight the spreadsheet, right click Copy then right click Paste into the same triangle or into cell A1 on the next tab, then repeat.

[Atheist]

jbw, What does the word 'like' signify? Does it mean you would like to create identical worksheets and give each one a different name? Or does it mean you've already created the sheets, and want to name them? (preferably without having to do it by hand).

[JBW1366]

I want excel to create a tab for each day of the year, with the date on the tab - with a worksheet I have created myself - so basically copy this sheet moving forward from todays date.. (for example) with this sheet - as I wanted to use as a diary as such.. where I can move things along..delete etc

[JBW1366]

Athiest - thanks for answering - I  would like to create identical worksheets and give each one a different name (a date) but is there an easier way than copying and pasting the sheet I have made up - can it do it automatically.? 

[THECORBYLOON]

Would it not be easier just to use the diary on Outlook for example?

 

[Atheist]

jbw. I can't help thinking that if you just copied rather than spending time here you might have got it done by now.

[newmodarmy]

Does this help?

https://support.microsoft.com/en-gb/office/move-or-copy-worksheets-or-worksheet-data-47207967-bbb2-4e95-9b5c-3c174aa69328#:~:text=Duplicate%20the%20sheet%20manually,-If%20you%20have&text=Keyboard%20shortcut%3A%20Press%20CTRL%2BSpacebar,add%20a%20new%20blank%20worksheet.

Or this 

Duplicate the sheet manually   Keyboard shortcut: Press CTRL+Spacebar, on the keyboard, and then press Shift+Spacebar. Copy all the data on the sheet by pressing CTRL+C. Select the plus sign to add a new blank worksheet. Select the first cell in the new sheet and press CTRL+V to paste the data.

Or this

https://edu.gcfglobal.org/en/excel-tips/how-to-quickly-duplicate-a-sheet/1/

[JBW1366]

Athiest- I think you may be right !