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.
