Forum Discussion
VBA to Move Row to Another Sheet when Drop Down Selected
I am so very new to VBA but I'm certain this is what I need to get me the functionality I'm looking for. I am currently working on updating our tracker for work. When "Paid" is selected from the drop down list, I need the entire row to move to it's corresponding sheet. The same when "Enforcement" or "Discharged" etc. are selected.
I have tried quite a few different codes I've found online that are similar to my situation but for one reason or another, I can't seem to make sense of it.
Any help is greatly appreciated!
Depending on what this master sheet is and how it's used, you might well be able to use FILTER (with appropriate criteria) and accomplish the same (or similar) functionality without VBA. Specifically, if the master sheet is primarily a transactional database, then you could have a dashboard that shows all that have been "Paid" or "Enforcement" or "Discharged" and keep the transactional database whole for the full history.
You'd help us help you--others might have VBA solutions--by posting a working copy (without real data, but enough "test cases" to do some testing) of an actual spreadsheet. If you can't post it here, use OneDrive or GoogleDrive and paste a link here that grants access.
- Nope. Not for someone not in sharepoint, at any rate.
