Forum Discussion
VBA to Move Row to Another Sheet when Drop Down Selected
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.
https://cmiloans-my.sharepoint.com/:x:/r/personal/lisa_richer_thecmigroup_ca/Documents/Desktop/October%20Default%20Tracker.xlsm?d=w028dd9762c5a46cb9c14b2ebda55824c&csf=1&web=1&e=Q7B5Q5
- mathetesSep 27, 2024Gold ContributorNope. Not for someone not in sharepoint, at any rate.