Hey,
I need to make one Excel for my personal work for 30 days tabs with date and day
For Ex. 01/02/13-Fri (in one tab)
02/02/13-Sat(in second tab)
Please Help.
Hey,
I need to make one Excel for my personal work for 30 days tabs with date and day
For Ex. 01/02/13-Fri (in one tab)
02/02/13-Sat(in second tab)
Please Help.
Hi Anasrizvi,
welcome to the forum.
You need these dates as Tab names or an entry some where in tab ?
Regards,
DILIPandey
<click on below * if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), [email protected]
I have created a sample template workbook for the expected task. The code I written for this is given below:
The SHEET / WORKBOOK is protected with a password which is nothing just my identity name without any case sensitivity.Please Login or Register to view this content.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Okay.. then it can not be achieved using formula and functions.. try using below macro (VBA ) code :-
Regards,Please Login or Register to view this content.
DILIPandey
<click on below * if this helps>
Hi Anas,
Copy this code and go to Excel window.
Press Alt + F11
press (Alt + i + m)
paste this code
press F5
Regards,
DILIPandey
<click on below * if this helps>
you are welcome..
Please mark this thread as [SOLVED], if you query is resolved.
Also, suggest you to avoid quoting whole posts. ..
Regards,
DILIPandey
<click on below * if this helps>
How Can i Change from Jan to Feb March Etc in the Code.
And if i want to print the same format which i am using in individual sheet in all the other 30 excel tabs how to do that?
Any code for that too?
Since its January hence code will generate sheet tabs for January...when you,ll be in Feb, code will generate sheets for Feb... don't worry on that part.How Can i Change from Jan to Feb March Etc in the Code.
Format is there in the code as "WorksheetFunction.Text(n + b, "dd-mmm-yy")",And if i want to print the same format which i am using in individual sheet in all the other 30 excel tabs how to do that?
You can change "dd-mmm-yy" as per your desired format.
Regards,
DILIPandey
<click on below * if this helps>
No Suppose on 1st Jan i have some format in that individual tab
and i want to copy that same format in all the 30 tabs with out copy paste.
like ex. Name Age Class Percentage Subjects
This is in 1 st Jan and i want to copy this all in 30 tabs how to do this
Hi Anasrizvi,
When I askedYou saidYou need these dates as Tab names or an entry some where in tab ?and now what you are asking is not related to this.. please create a separate thread for your new request and mark current thread as [SOLVED]. thanks.I need this as a new tab name.
Regards,
DILIPandey
<click on below * if this helps>
Solved my problem...
Cheers
Please mark this thread as [SOLVED]...
" Click Thread Tools above your first post, select "Mark your thread as Solved". Or click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Dropdown option or Edit button will not appear -- ask a moderator to mark it."
Regards,
DILIPandey
<click on below * if this helps>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks