I need an Excel Calendar with EACH Tab a different Day of the year in concession starting with January 2022 - The Macros are outlined attached similar to this. So the First Tab will be Sat Jan 01 - Next - Sun Jan 02 and so forth. Then ON each Tab should be the date and times as in SAMPLE II Attached - So the day on each sheet should match the tab accordingly. Can anyone help>?
basically i need copy data from active sheet and create new sheet with with rename the sheet of date next to active sheet date...
Example: Sheet1 have date and in cell B2 date:13/09/21 so through vba create a new sheet copy data from sheet1 and change date in new sheet cell B2 14/09/21 and name of new sheet should be date in B2 cell..
I see no macros ??????
A tab per day - 365 days/year - you are going to run out of tabs very quickly.
Give the attached approach a try - you can adapt to your needs.
double click on specific day/time - pop-up form for data input - if you click on filled cell 'note' pops up - double click 'update'/'delete' form pops up.
you can tailor the code to suit your application.
Torachan,
Mission statement; Promote the use of Tables, Outlaw the use of 'merged cells' and 'RowSource'.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks