Link entries between sheets

[Francois Bekker]

I have 2 sheets in Excel. The one sheet contains monitoring data which is identified by a trap no. There are several entries for each trap. Therefore the trap number is repeated. My problem is that there are inconsistencies in the trap number which can only be identified manually. My idea is to have a lists of the traps in a second sheet, then remove all duplicate trap numbers, to see only a list of all the unique trap numbers. In this way the inconsistencies will be much easier to spot.

What I want excel to do is when I fix a trap number in sheet 2 it must fix all the entries of that specific trap in sheet 1 automatically.

Is this possible?


Extract from Sheet 1: the column "Area_Plaas_Boord_Trap" is the trap name which was combined using the following formula "=(c2&"-"&d2&"-"&f2&"-"&g2)

---

A B C D E F G H I J K L M N

Year	Week	Area	Plaas	Vrugsoort	Boord/verwysing	Trap no.	SM	WM	WW	NV	B.INV	FCM	Area_Plaas_Boord_Trap
2011	6	Grabouw			Bosbou Huise	3	0	7	9	0	n/a	n/a	Grabouw--Bosbou Huise-3
2011	9	Grabouw			Bokkie Huis	10	2	10	17	0	n/a	n/a	Grabouw--Bokkie Huis-10
2011	11	Grabouw			Bokkie Huis	10	0	5	12	0	n/a	n/a	Grabouw--Bokkie Huis-10
2011	12	Grabouw			Bokkie Huis	10	0	0	0	0	n/a	n/a	Grabouw--Bokkie Huis-10
2015	7	Grabouw		PL/RG	BD	402B	0	0	0	0	0	n/a	Grabouw--BD-402B
2009	41	Villiersdorp	A. McDonald		Kantoor		0	0	0	0	n/a	n/a	Villiersdorp-A. McDonald-Kantoor-
2009	43	Villiersdorp	A. McDonald		Kantoor		0	0	0	0	n/a	n/a	Villiersdorp-A. McDonald-Kantoor-
2009	44	Villiersdorp	A. McDonald		Kantoor		0	0	0	0	n/a	n/a	Villiersdorp-A. McDonald-Kantoor-
2009	45	Villiersdorp	A. McDonald		Kantoor		0	0	0	0	n/a	n/a	Villiersdorp-A. McDonald-Kantoor-

<colgroup><col><col span="2"><col><col><col><col><col><col span="2"><col><col><col><col></colgroup><tbody>
</tbody>

---

Example of sheet 2 which contains only the unique trap names (duplicates removed).

---

Area_Plaas_Boord_Trap

Grabouw--Bosbou Huise-3

Grabouw--Bokkie Huis-10

Grabouw--BD-402B

Villiersdorp-A. McDonald Kantoor-

<colgroup><col></colgroup><tbody>
</tbody>

---

What I want to do is the following.

When I change a trap name in sheet to it must change all the entries of that trap name in sheet 1.

For example I change the trap name "Villiersdorp-A. McDonald Kantoor-" in sheet 2 to the following: "Villiersdorp-A. McDonald Kantoor-555"

All the "Villiersdorp-A. McDonald Kantoor-" traps in sheet 1 should change to "Villiersdorp-A. McDonald Kantoor-555".

---

Seeing that column N in sheet 1 is produced by column C, D, F and G it would be great if these columns can also change when the fix is done in sheet 2.

Thank you in advance.