This will do all with the macro
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Column <> 1 Then Exit Sub
With Sheets("Sheet2")
.Range("H6") = Target
.Range("d9") = Target.Offset(, 1)
.Range("d11") = Target.Offset(, 2)
End With
End Sub
-----Original Message-----
From: Dilip Pandey
Sent: Wednesday, August 17, 2011 11:36 PM
To: excel-macros@googlegroups.com
Cc: vickey
Subject: Re: $$Excel-Macros$$ copy cell value from clicked hyperlink
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
--
----------------------------------------------------------------------------------
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
