Hello!
I have a workbook with 2 sheets.
1. "Source Sheet"
2. "Edit Sheet"
On "Edit Sheet" i have the =UNIQUE formula that is replicating the Source Sheet
My Goal: Use the Edit Sheet to filter column D (which contains an ID number) for a 1 or more values, then switch over to Source Sheet and replace the row contents with a 0 on the row where that ID number is found.
I plan to put a button on the Edit Sheet which will run this proposed macro, but have it warn the user that something needs to be filtered prior to running the code, as they could potentially wipe-out the entire sheet otherwise!
Any help would be appreciated! Sample spreadsheet attached!
Bookmarks