dropdownlists: month & year to autofill weekdays in a column
Hi all,
I'm fairly new to VBA and would appreciate any help you can provide with the following problem. I am trying to make a spreadsheet that records the number of hours I've worked each month.
I have two drop down lists: one containing months (in the format "January", "February"...) the other containing years ("2011", "2012"...).
When I select any combination I want Excel to autofill a column with the weekdays of that month in the format dd/mm/yyyy.
I'm not sure where to begin, but I have recorded a macro by manually filling in the first date of the month and using the autofill feature down the column; I just don't know where to go from here...
Cheers,
Jim
Hi Jim
Welcome to the Forum!
How about posting what you haveI have two drop down lists: one containing months (in the format "January", "February"...) the other containing years ("2011", "2012"...).and what you'd like it to beI have recorded a macro by manually filling in the first date of the month and using the autofill feature down the columnShow us a before and after...perhaps we can help.When I select any combination I want Excel to autofill a column with the weekdays of that month in the format dd/mm/yyyy
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks