Hello There,
I have a workbook which contains 4 worksheets. These worksheets contains Tables. The common column across these worksheets is the Primary Key called 'Code'.
The requirement is as follows:
1. The current active worksheet is 'Sheet1'. The user cursor is on row whose 'Code' is XX-204.
2. When the user clicks on worksheet 'Sheet2', the cursor should be placed on row whose Code = XX-204.
3. The same goes for other sheets as well and vice versa.
I have attached the sample workbook for your reference.
Could you please advise on how this can be achieved?
Looking forward to hearing from you.
Thanks & regards
Don
I have a workbook which contains 4 worksheets. These worksheets contains Tables. The common column across these worksheets is the Primary Key called 'Code'.
The requirement is as follows:
1. The current active worksheet is 'Sheet1'. The user cursor is on row whose 'Code' is XX-204.
2. When the user clicks on worksheet 'Sheet2', the cursor should be placed on row whose Code = XX-204.
3. The same goes for other sheets as well and vice versa.
I have attached the sample workbook for your reference.
Could you please advise on how this can be achieved?
Looking forward to hearing from you.
Thanks & regards
Don