How To Get Excel To Dynamically Update One Worksheet With The Rows Of Another If Criteria Match
Ok, this is the setup, worksheet1 is my master list with tons of info; one column named 'Approvers' is populated with names. Would like to make other worksheets 2, 3 etc. that only contain the rows that have corresponding 'Approver'; as i make changes or add rows with data the worksheet will check for the Approver name and automatically copy that row to the appropriate worksheet. Otherwise I'll be stuck making updates to multiple worksheets whenever there's a change.
I'm sure there's a way to do this, thank you soooo much for your help!
Microsoft ExcelMicrosoft OfficeSpreadsheets
8/22/2022 - Mon
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.