Macro /VBA code for cross reference

[Prakash Mimrot]

I have data in cell as R15TB1:2 and on another cell as R14TB1:2 this means there are two cell which has interconnections, means from R15's TB1's point#2 it will go to R14's TB1's 2. I want this to be checked with a single button using macro and error list to be generated. If required I shall share the excel sheet.

your help would be appreciated!

 

[JLGWhiz]

If I saw this, How would I know which is an error?

R12TB1	R15TB2
R22TB2	R16TB4
R18TB3	R18TB1

<colgroup><col width="77" style="width: 58pt;" span="2"> <tbody> </tbody>

 

[Prakash Mimrot]

	R14		R15
	TB1		TB1
1		1	R14TB16:7
2	R15TB1:2	2	R14TB1:2
3	R15TB16:6	3	R14TB1:7
4	R15TB1:4	4	R15TB1:3
5	R15TB16:4	5	R16TB1:1
6	R15TB1:6	6	R16TB1:6
7	R15TB1:3	7	R16TB1:7
8	R19TB1:3	8	R16TB1:8
9	R15TB5:9	9	R16TB1:9
10		10	R16TB1:10
11		11	R14TB15:5
12		12	R16TB1:3

<tbody>
</tbody>

Thanks for your reply.
1.Correct referece
Please see the text in serial number 2, in column R14 from TB1 R15TB1:2 means in R15 at TB1 location it should have reference as R14TB1:2. This is what is required to checked and if it is not correct it should give a list of error.

2.Incorrect reference Please see serial number 4, in column R14 from TB1's point 4 it should go to R15, TB1's point number 4 but it not.

I have shown for two columns but there will be at least 50 columns.

Its is like at point a it will be from b and at b it will be from a.

 

[JLGWhiz]

	R14		R15
	TB1		TB1
1		1	R14TB16:7
2	R15TB1:2	2	R14TB1:2
3	R15TB16:6	3	R14TB1:7
4	R15TB1:4	4	R15TB1:3
5	R15TB16:4	5	R16TB1:1
6	R15TB1:6	6	R16TB1:6
7	R15TB1:3	7	R16TB1:7
8	R19TB1:3	8	R16TB1:8
9	R15TB5:9	9	R16TB1:9
10		10	R16TB1:10
11		11	R14TB15:5
12		12	R16TB1:3

<tbody>
</tbody>

Thanks for your reply.
1.Correct referece
Please see the text in serial number 2, in column R14 from TB1 R15TB1:2 means in R15 at TB1 location it should have reference as R14TB1:2. This is what is required to checked and if it is not correct it should give a list of error.
























2.Incorrect reference Please see serial number 4, in column R14 from TB1's point 4 it should go to R15, TB1's point number 4 but it not.

I have shown for two columns but there will be at least 50 columns.

Its is like at point a it will be from b and at b it will be from a.

Sorry, I still don't understand what you are looking for.