The problem is then I need a create hyperlink manually.. Then I need to create hundreds hyperlink..
Also, everytime I click the cell, it takes me to the reference cell, which I don't want to. I want to go to the reference cell when I want to. That's why I don't think Hyperlink is a solution. Due to system problems, I am doing Reconcilation manually with thousands data. Creating a hyerlink for every cell I need to link is too much time consuming. I don't think it will be a complicated macro.. Get the value from a cell... if the value is workbook.;.. open the workbook and go to the reference cell if the value is a cell, go to the cell well, I think this logic will work.. I just don't know how to write this.. Anyone please? ^ ^ On Mon, Mar 22, 2010 at 5:57 PM, Yahya <yahya...@gmail.com> wrote: > Dear Mark > > I think you can do it by just using a Hyperlink. No need for macros. > Please see the attached file > > Yahya > > > > On Mon, Mar 22, 2010 at 2:37 AM, Markkim <mark....@gmail.com> wrote: > >> Hi >> >> I am wondering if anyone can help me creating a macro for the >> following.. >> Get a reference from the selected cell and take me there . >> For example, A1 contains C4. The macro will take me to C4. This is a >> very simple one. >> A1 contains a reference Sheet2!C4. I’d like the macro to take me >> sheet2 C4. >> And if A1 contains a location of the other file. Let’s say… A1 >> contains Sheet ‘sales’ C4 in the file named ‘Sales’. Then I want the >> excel to open the file and take me to C4 in a sheet called ‘sales’. >> I want a button to get back to where I was. >> >> Can you create a macro like this? >> >> -- >> >> ---------------------------------------------------------------------------------- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our Facebook Group @ >> http://www.facebook.com/group.php?gid=287779555678 >> 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 >> >> <><><><><><><><><><><><><><><><><><><><><><> >> HELP US GROW !! >> >> We reach over 6,800 subscribers worldwide and receive many nice notes >> about the learning and support from the group.Let friends and co-workers >> know they can subscribe to group at >> http://groups.google.com/group/excel-macros/subscribe >> >> To unsubscribe from this group, send email to excel-macros+ >> unsubscribegooglegroups.com or reply to this email with the words "REMOVE >> ME" as the subject. >> > > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe from this group, send email to excel-macros+unsubscribegooglegroups.com or reply to this email with the words "REMOVE ME" as the subject.
