Hello,
I have an expense report spreadsheet that I want users to fill out monthly. Based on what they enter in certain columns, I'd like the spreadsheet to automatically generate an accounting code. The only problem is that certain fields require multiple entries.
For example, a purchase can be made for multiple locations so users would potentially need to be able to select San Antonio, Dallas, Austin, etc. from one drop down box. I found a macro at contextures.com (below) which allows me to do exactly this.
However, I need this macro to work in multiple columns like Location, Department, Expense Type, etc. I have attached the spreadsheet from where I got the macro. It's under the "SameCellAddRemove" tab. For some reason, the macro doesn't allow for this to be used in multiple columns. Does anyone know what the problem is or how I can fix this?
Any help is appreciated.
Thanks.
Bookmarks