Hyperlink a cell from one sheet with a matching cell in another sheet

[cwryan]

Hi all

I have two sheets. Sheet 1 is a front cover sheet that has general pass/fail info on tests being carried out on a unit. each unit is given a reference number

A B C D E F
1 Ref No. Unit No. Date Test 1 Test 2 Test 3
2 1 1 01/01 Pass Pass Pass
3 2 2 02/01 Pass Pass Pass
4 3 3 03/01 Pass Pass Pass
5 4 4 04/01 Pass Pass Pass

Sheet 2 is the actual test data for each unit which has a reference number that matches the one given to it in sheet A

A B C D E
1 Unit 1 Ref No. Test Data Test Data Test Data
2
3
4
5


I would like to match the reference number cells on both sheets and then create a hyperlink from the reference number in sheet1 to the relevant test data in sheet2

The VBA code i have written so far is

Please Login or Register  to view this content.

It doesn't seem to be doing anything when run so any help would be appreciated

Thanks

[jmac1947]

welcome to the forums

exactly what code have you tried so far, please post a current sample workbook that shows the inputs and expected results and maybe you will get some assistance

I see this is your first post, so welcome...

The forum is where volunteers provide assistance to others on how to solve a particular problem rather than a complete solution. A sample workbook allows those of us with limited time to maximize our help to others

Jmac

[cwryan]

So sheet1 will look like,

	A	B	C	D	E	F
1	Ref No.	Unit No.	Date	Test1	Test2	Test3
2	1	1	01/01	Pass	Pass	Pass
3	2	2	02/01	Pass	Pass	Pass
4	3	3	03/01	Pass	Pass	Pass
5	4	4	04/01	Pass	Fail	Pass

And Sheet2 will look like,

	A	B	C	D	E
1	Unit No.	Ref No.	Test Data1	Test Data2	Test Data3
2	1	1

When the two reference numbers match (A2 on sheet1 and B2 on sheet2). I would like a hyperlink to be created on A2 of sheet1 to link to B2 of sheet2. This would need to be done for several different matching references that could be out of sync on sheet2