Avatar of wtchandler
wtchandler
 asked on

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

Avatar of undefined
Last Comment
wtchandler

8/22/2022 - Mon
gowflow

yes for sure could you post a sample of the data so we can get you this correctly ? (make sure you also post the worksheet's real name that need to be updated as well.
gowflow
Rob Henson

You can use the Advanced Filter function to achieve this; I have answered similar question in that vane so might be worth a search for Advanced Filter while I try and find previous questions.

Thanks
Rob H
wtchandler

ASKER
Thank you for responding, I've prepared a sample worksheet as you requested. So for example I'm trying to have rows in the first worksheet  who's value under the column named 'Plan Approvers' match the criteria i set (Jane Doe) automatcially be copied to another worksheet.
This datasheet will be edited often so I want to make sure when I change the name of an approver that their name is removed from one worksheet and added to another worksheet that corresponds to the new name.

THank you so much for your time and patience, your help is appreciated.
sample-worksheet.xlsx
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.
rwheeler23
wtchandler

ASKER
I'm trying problems using the 'Advanced Filter', its giving me reference errors when copying across worksheets.
Rob Henson

Just thought, you might be able to use pivot tables as instead.
wtchandler

ASKER
How about is there a way to mirror the first worksheet on the second worksheet but apply filters to the second worksheet.  That way any changes made to either are updated on the other?
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Rob Henson

That's what a pivot table would do for you using the Page field for the approver.
ASKER CERTIFIED SOLUTION
wtchandler

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
wtchandler

ASKER
No one really provided a solution for what I was asking. I figured it out myself.