Automatic Updating

I have a workbook with different worksheets for tracking the daily accountability of employees assigned to my organization . The main worksheet (Tab A) is a list of all employees assigned to my organization. I have another worksheet (Tab B) that I want to list all employees from TAB A who are working in a specific department. I want the employees on Tab B to automatically be added, updated, or deleted based on the changes that are made to them on Tab A. I only need certain information from from the employee's row on Tab A to be added on the row on Tab B. I have no expericence writing code and am not sure what the best method is to accomplish this task. I will appreciate any help.

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

Two minds, one thought....

remarkable and the same message as well ! uncanny

Ah, well, that's effective moderator training!!

How does apicture help? You were asked by tow mods to attach a dummy workbook!

Maybe something like this helper column sheet 1 col a

How could I use this formula if I wanted to include a second location?

with a slight alteration

you forgot to mention your cross post at code cage !
i've answered the second part there. but its not in alphabetical order
but that's easily rectified if you just sort the oif sheet by surname

its just etiquette to post links to any cross posts(and it is a forum rule) i could be working away for an hour or 2 only to find out someone had done the same thing already.
anyway try this
(note: the easiest way is to always sort oif sheet not the others)
ive only allowed for up to 200 rows you'll have to change anything that refers to row 201 to something bigger if you need more

Your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us help you!

Read this to understand why we ask you to do this

A friend of mine suggested that I try a few different sites.

And while you're at it: please send your friend the link to the site above as well. General forum etiquette requires that you name all forums where you post the same question.