Excel 2016 Automate some worksheets
Solved/Closed
ForeverLearning
Posts
2
Registration date
Saturday December 26, 2015
Status
Member
Last seen
December 27, 2015
-
Dec 26, 2015 at 08:24 AM
ForeverLearning Posts 2 Registration date Saturday December 26, 2015 Status Member Last seen December 27, 2015 - Dec 27, 2015 at 12:27 AM
ForeverLearning Posts 2 Registration date Saturday December 26, 2015 Status Member Last seen December 27, 2015 - Dec 27, 2015 at 12:27 AM
Related:
- Excel 2016 Automate some worksheets
- Microsoft access 2016 free download - Download - Databases
- Kmspico office 2016 - Download - Other
- Outlook 2016 download - Download - Email
- Microsoft publisher 2016 free download for windows 10 - Download - Publishing
- Transfer data from one excel worksheet to another automatically - Guide
1 response
BrianGreen
Posts
1005
Registration date
Saturday January 17, 2015
Status
Moderator
Last seen
September 30, 2021
150
Dec 26, 2015 at 01:57 PM
Dec 26, 2015 at 01:57 PM
Hi ForeverLearning
First of all, I'm not an Excel expert, but am learning fast.
Unfortunately Excel doesnt provide the renaming of worksheets natively. However, it can be done with a macro, but this would require you to run the macro every time the cell A1 is changed. The following website discusses this:
https://excel.tips.net/T002145_Dynamic_Worksheet_Tab_Names.html
As for naming the A1 cell in every sheet, try this, but unfortunately it meeds a full date to be inputted somewhere:
In Sheet 1 Cell A1 type
In Sheet 2 Cell A1 type
In Sheet 3 Cell A1 type
Keep going until you have the required number of sheets.
In Sheet 1 Cell B1 type a date with the month you need in Sheet1 Cell A1
Hope this works for you ... at least till you find a better way.
I really appreciate thank you messages as a payment for solving issues :o)
First of all, I'm not an Excel expert, but am learning fast.
Unfortunately Excel doesnt provide the renaming of worksheets natively. However, it can be done with a macro, but this would require you to run the macro every time the cell A1 is changed. The following website discusses this:
https://excel.tips.net/T002145_Dynamic_Worksheet_Tab_Names.html
As for naming the A1 cell in every sheet, try this, but unfortunately it meeds a full date to be inputted somewhere:
In Sheet 1 Cell A1 type
=CHOOSE(MONTH(B1),"JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC")
In Sheet 2 Cell A1 type
=CHOOSE(MONTH(Sheet1!B1)+1,"JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC")
In Sheet 3 Cell A1 type
=CHOOSE(MONTH(Sheet1!B1)+2,"JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC")
Keep going until you have the required number of sheets.
In Sheet 1 Cell B1 type a date with the month you need in Sheet1 Cell A1
Hope this works for you ... at least till you find a better way.
I really appreciate thank you messages as a payment for solving issues :o)
Dec 27, 2015 at 12:27 AM
Cheers
Mark
(ForeverLearning)