Hello Dear, You can use go to reference.Sample sheet with code is attached. I think it will help you.
Hope it will Help Happy To Help :) Shyam On Tue, Mar 23, 2010 at 5:19 AM, Spud <dean.t...@gmail.com> wrote: > Can you post an example showing how the format of the cell values (you > mention that the cell value can be a workbook and a cell: does it show > the path correctly for the workbook? Unless you know the correct path > for the workbook, or they're all in the same path/folder, then it > would be impossible to open the correct workbook). > > If by cell value you actually mean formula (ie. in cell A1 you have > the formula =Sheet 2!A3) then you could just go into tools>options and > untick edit directly in cell, and then when you double click in cell > A1 it will take you to > Sheet 2!A3. This will also open up the workbook if the formula is > ='[Book1.xls]Sheet 2'!$A$3. Unticking edit directly in cell will mean > you can't edit formula's in the cell, you have to do it in the formula > bar. > > Cheers, > > Spud > > On Mar 22, 10:34 pm, Mark Kim <mark....@gmail.com> wrote: >> 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 athttp://www.excel-macros.blogspot.com >> >> 4. Learn VBA Macros athttp://www.quickvba.blogspot.com >> >> 5. Excel Tips and Tricks athttp://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. > -- Thanks Regards Shyam Software Engineer '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' When one door of happiness closes, another opens; but often we look so long at the closed door that we do not see the one which has been opened for us. - Helen Keller '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' Wenn eine Tür des Glücks schließt, öffnet sich ein weiteres, aber oft schauen wir so lange auf die geschlossene Tür, dass wir nicht sehen ein, die für uns geöffnet wurde. - Helen Keller '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' -- ---------------------------------------------------------------------------------- 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.
Reference linking.xls
Description: MS-Excel spreadsheet
