hi
how can we use hyperllink with vlookup() to data transfer between sheets
i atttached the workbook file with this
if i click on sheet1 serial number "2" on sheet2 it shows the serial no2 row.
everytime when i click on different serial numbers the data on sheet 2 will updated according to that serial number....
please see attached file to see my requirement......
Duplicate post. Solution for click/transfer already posted in original thread, post #10.
http://www.excelforum.com/excel-work...-row-data.html
Last edited by JBeaucaire; 10-28-2010 at 10:48 AM.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
but that transfer the row in next empty row
the solution i want to update the same row and only one row will be shown in sheet2 which is clicked in sheet1
another thing it is not automatically shown the sheet2 on click and it is working on double click not on single.......
Is the correct solution for the other thread posted in that thread? If not, say so in that thread and continue this conversation in that thread.
If the solution offered was correct, say so in that thread and officially close that thread. That means this is thus a completely new need? If this is a completely new need, different from the other thread, this new thread would be appropriate, I suppose.
When you don't answer and close out your old threads, we assume you don't know how to use the forum properly when we see that same question again (or what appears to be).
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks