Hello,

Feel free to move this post to a more appropriate place if I have posted in the wrong place (this is my first post).

General problem description:
I would like information(cells containing text and other cells containing numbers) from mulitple column ranges in sheet 1 to be automatically mirrored to sheet 2 but only for those rows that contain a specific keyword or number.

Excel spreadsheet situation:
Information in sheet 1 is inputted manually and contains compiled organisational information in columns containing:

A: Vacant [Numbers](entered 1 if position is filled, 0 if vacant).
C: Town [TEXT]
D:Building [TEXT]
F: Area of responsibility [TEXT]

What I want to do:
I want to enter information "once only" in Sheet 1, then "showcase" it in other Sheets and other sheets gets automatically updated. This is to prevent forgetting to update a list if a standard ctrl+v solution is used.

Example 1: I want to only show the staff working in a particular town on sheet 2. If I edit information in sheet1 in any way (deleted, edit or add a new row) I want to
see the change reflexted automatically in sheet 2 without any further user input.

Example 2: I want to show how many areas of responsibilities that are vacant(Cellinfo=0) and mirror the rowinformation in that case. This information is put on sheet3.

Thank for any and all help.
/Chris