Multiple list entries in multiple cells

[dushtin]

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.

Please Login or Register  to view this content.

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.

[dushtin]

Forgot to include that the way I tried to make this work for other columns was to simply past the macro again and change the names of rngDV, oldVal, newVal, etc. Target, and lused to something different (rngDV2 for example). I also changed "If Target.Column = 20 Then" to "If Target.Column = 21 Then".

[dushtin]

Nevermind. Figured it out and now I feel silly.

For those wondering what I did, If "Target.Column = 20" just needed to be changed to If "Target.Column = 20 or 21 or 22 etc..."

Can a mod please close this?