VeeraSinha
New Member
- Joined
- Jul 6, 2009
- Messages
- 8
Hi,
I have 2 workbooks in the same file. WKBK1 "main" has 2 columns . col 1 is a list of part numbers and col 2 if the "totalcost" of that part number. WKBK2 has 4 columns, first col is same list of parts and col 4 if the total cost and col 2 and 3 are break up of that cost.
I need to make the total cost cell in wkbk1 as a clickable link. so the user can see the cost break up in wkbk 2 . on clicking i need the cursor to go to the matching part row and total cost col in wkbk2.
Heres what I am trying anf the resul is the total cost as a clickable link but when I click on it i get an error. "Can not open the specified file"
=HYPERLINK(VLOOKUP(A18,Details!A:P,16,FALSE))
Please please help . I have a deadline coming up.
Thanks in advance.
Veera
I have 2 workbooks in the same file. WKBK1 "main" has 2 columns . col 1 is a list of part numbers and col 2 if the "totalcost" of that part number. WKBK2 has 4 columns, first col is same list of parts and col 4 if the total cost and col 2 and 3 are break up of that cost.
I need to make the total cost cell in wkbk1 as a clickable link. so the user can see the cost break up in wkbk 2 . on clicking i need the cursor to go to the matching part row and total cost col in wkbk2.
Heres what I am trying anf the resul is the total cost as a clickable link but when I click on it i get an error. "Can not open the specified file"
=HYPERLINK(VLOOKUP(A18,Details!A:P,16,FALSE))
Please please help . I have a deadline coming up.
Thanks in advance.
Veera
Last edited: