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...
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.
