Macro /VBA code for cross reference

Prakash Mimrot

New Member
Joined
Dec 31, 2016
Messages
2
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!
 

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying

JLGWhiz

Well-known Member
Joined
Feb 7, 2012
Messages
12,979
Office Version
  1. 2013
Platform
  1. Windows
If I saw this, How would I know which is an error?
R12TB1R15TB2
R22TB2R16TB4
R18TB3R18TB1
<colgroup><col width="77" style="width: 58pt;" span="2"> <tbody> </tbody>
 
Upvote 0

Prakash Mimrot

New Member
Joined
Dec 31, 2016
Messages
2
R14
R15
TB1
TB1
11R14TB16:7
2R15TB1:2 2R14TB1:2
3R15TB16:6 3R14TB1:7
4R15TB1:44R15TB1:3
5R15TB16:4 5R16TB1:1
6R15TB1:6 6R16TB1:6
7R15TB1:3 7R16TB1:7
8R19TB1:38R16TB1:8
9R15TB5:99R16TB1:9
1010R16TB1:10
1111R14TB15:5
1212R16TB1: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.
 
Upvote 0

JLGWhiz

Well-known Member
Joined
Feb 7, 2012
Messages
12,979
Office Version
  1. 2013
Platform
  1. Windows
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.
 
Upvote 0

Forum statistics

Threads
1,195,947
Messages
6,012,470
Members
441,701
Latest member
vnkendijs

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top