Hi Vickey,
Hyperlink can never copy values from one place to another, hence given a two line code which will help you :) Let me know if this helps you. Regards, DILIPandey On 8/4/11, vickey <vikasda...@gmail.com> wrote: > Hi, > > Thanks for the same,but my problem has not yet been solved....... > > Please refer attached sample file........ > > in sheet1 there is Sr. no. name & particular and in sheet2 there is format > like receipt. > now I want that I click sr.no. from sheet1 that sr.no. should copied or > entered in sheet2 H6 cell, because it will minimize the time typing the > number, which will help a lot. > > Vickey > > On Thursday, 4 August 2011 10:32:51 UTC+5:30, DILIPandey wrote: >> >> Hi Vickey, >> >> Based on your description, attached is the solution. Let us know if this >> works. >> >> Thanks, >> DILIPandey >> >> On 8/3/11, vickey <vikas...@gmail.com> wrote: >> > Is there any way to to get cell value from clicked cell hyperlink. >> > >> > i.e. if there is sr.no. 1 in cell A1 in sheet1 and it is hyper linked >> > with sheet2 the value of sheet1 A1 (1) should reflect in Sheet2 A1 or >> > anywhere. >> > >> > Please help me out to get it solved. >> > >> > thanks in advance...... >> > >> > >> > vickey >> > >> > -- >> > >> ---------------------------------------------------------------------------------- >> > Some important links for excel users: >> > 1. Follow us on TWITTER for tips tricks and links : >> > http://twitter.com/exceldailytip >> > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> > 3. Excel tutorials at http://www.excel-macros.blogspot.com >> > 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> > >> > To post to this group, send email to excel-...@googlegroups.com >> > >> > <><><><><><><><><><><><><><><><><><><><><><> >> > Like our page on facebook , Just follow below link >> > http://www.facebook.com/discussexcel >> > >> >> >> -- >> Thanks & Regards, >> >> DILIP KUMAR PANDEY, mvp >> MBA,B.Com(Hons),BCA >> Mobile: +91 9810929744 >> dilip...@gmail.com >> dilip...@yahoo.com >> New Delhi - 62, India >> >> -- Thanks & Regards, DILIP KUMAR PANDEY, mvp MBA,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Hyperlink with a click by DILIPandey.xls
Description: MS-Excel spreadsheet