Update Other Worksheets When Updating Main Worksheet

[something68]

I created a Personnel List as worksheet 1. I copied to a new worksheet and deleted rows so that the worksheet will just be cashiers, then copied again and deleted so the 3rd sheet will be just stock clerks and a 4th sheet of just deli workers.

I want to make a change on the first sheet, i.e., change a stock clerk to deli worker, so that it automatically updates other sheets.

 

[Candyman8019]

If you download the workbook I attached, you just need to add additional people to the Personnel tab and they'll also show up on the other tabs accordingly

 

[something68]

You'll need to make sure there is nothing in the cells below the formula, and you'll also need to change the tab names in the formula to match your workbook

I chose a cell outside of the print area and changed on the ALL employees list, even tried on Lancaster list:

=UNIQUE(FILTER(Personnel!$A$2:$A$401,(Personnel!$B$2:$B401="Lancaster")*(Personnel!$C$2:$C401="Avondale"))) It didn't seem to work (it brought up the choose a file), so I tried

=UNIQUE(FILTER(Personnel!$A$2:$A$401,(Personnel!$B$2:$B401="Lancaster")*(Personnel!$C$2:$C401="Avondale"))), again, didn't work, giving me the #CALC!

 

[something68]

I chose a cell outside of the print area and changed on the ALL employees list, even tried on Lancaster list:

=UNIQUE(FILTER(Personnel!$A$2:$A$401,(Personnel!$B$2:$B401="Lancaster")*(Personnel!$C$2:$C401="Avondale"))) It didn't seem to work (it brought up the choose a file), so I tried

=UNIQUE(FILTER(Personnel!$A$2:$A$401,(Personnel!$B$2:$B401="Lancaster")*(Personnel!$C$2:$C401="Avondale"))), again, didn't work, giving me the #CALC!

 

[Candyman8019]

If it's asking you to choose a file, you likely don't have a sheet called 'Personnel'.

Also, I have no idea what your workbook looks like, so you may have to adjust the column references as well. In my example, the person's name is column A, Role in column B, and location in column C.

 

[something68]

 

[Candyman8019]

Your names are column A, role in Column E and Location in Column B...all on the 'Personnel List' sheet...

In that case your formula would look like:
=UNIQUE(FILTER('Personnel List'!$A$2:$A$401,('Personnel List'!$E$2:$E401="stock clerk")*('Personnel List'!$B$2:$B401="Avondale")))

This will give you the list of names and then can use xlookup to bring other relevant columns in.

 

[something68]

Your names are column A, role in Column E and Location in Column B...all on the 'Personnel List' sheet...

In that case your formula would look like:
=UNIQUE(FILTER('Personnel List'!$A$2:$A$401,('Personnel List'!$E$2:$E401="stock clerk")*('Personnel List'!$B$2:$B401="Avondale")))

This will give you the list of names and then can use xlookup to bring other relevant columns in.

 

[something68]

That did not work. I am going to scrap this project and try something else. This is way too much work for something I though would be sort of simple.

Thanks for your time.