Update information in sheet 2 by changing sheet 1

[dklatt]

I am working on a phone list for my company which has multiple divisions.
I have multiple sheets in my workbook.

Sheet 1 is a complete employee list. Column headings are EXT. LOC. EMPLOYEE. CELL. HOME. OTHER. TITLE/POSITION.

The division locations are INDY, BLUFF, WEST, FW, TH.

I would like to be able to create seperate sheets for each location that will automatically populate and update with the information from sheet 1. I know how to use simple formulas for cell B3 in sheet 2 to equal a cell in sheet A, however if the Master list - Employee list is sorted in a different manner the data is no longer correct in the following sheets bc it is copying from a specific cell instead of specific data.

I want to be able to update information in the master employee list and have it update in the other division location sheets.

Can anyone help?

Thanks !!

[tony h]

use a pivot table. With the location as a filter. Depending on why you are trying to do this you may find one sheet with a location selector will do the job.


This isn't a programming issue; so it should be posted in Excel General.