I have monthly sheets(Jan to Dec)
In a specific cell of each sheet I need the drop down list of dates for each month.
Currently I am doing Data Validation - List Type
Collecting monthly date range from the Master Sheet
Is there is any other way...
Suggestions Please.
Attachment for your reference
I'm not sure what you mean by this?Will help you come up with alternatives but first need to understand why you don't like the data validation (so I don't come up with something just as bad).i have to make a date entry in ListMasterSheet and again have to come back to do List type data validation in specific cell range
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Well thanks for your time.
Basically i dont want to refer the date from the other sheet. Because every year i have to change date list in ListMaster Sheet. Thats the reason
I would set up a list that updates itself yearly. For your listmaster sheet, in B1
=DATE(YEAR(TODAY()),COLUMN(A1),ROW(A1)) dragged across and down. Clear anything over the limit for any month.
To take into account leapyears in C29
=IF(DAY(DATE(YEAR(TODAY()),3,0))=29,DATE(YEAR(TODAY()),COLUMN(B29),ROW(B29)),"")
Would that work for you?
Yes! That solved my purpose ... Thank you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks