Resetting drop down menu to first item/blank

[SGArete]

In my personal checkbook spreadsheet, I created a drop down menu in order to sort each entry into a corresponding tax category. Rather than go through and reset each row manually (Approximately 75 - 150 rows X 12 months), I searched for a way to do this quickly and easily. For clarification, the workbook has 13 sheets, one sheet each for January through December and an End of Year Totals page. One button would be great. Even a button on each page would be fantastic. If there is a better way, feel free to educate me! I found the following thread and attempted to use the suggestions and code I found in it but have been unable to get it to work.

https://www.excelforum.com/excel-pro...m-in-list.html

This is my first experience with code in Excel so this newbie would be grateful if someone would please explain what I might be doing wrong.

[yujin]

Hi, SGArete.

Why don't you attach the dummy workbook like the thread you linked?

[SGArete]

Good point. Here it is. I had started to delete some manually before deciding that was too time consuming.

[bakerman2]

I don't see the problem because this works in your example file.

Please Login or Register  to view this content.

[SGArete]

Thank you! Not sure why the previous code didn't work, but as you said, this worked perfectly! Once more, Thank you!

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.