Hi Spud I mean for example, Cell A1... I have a formula = Sheet2!A3.
I have a worksheet for for example Feb GST incurred ... (I have lots which are to caculate for exmpale.. FBT, Deposits.. different types of costs.. ) And i also have a workbook (separate file) which summarize all of these worksheets.. I can not have a absolute value for any of numbers presented in this summary.. All have to be linked.. simply.. All the value cells have a formula such as =[GST.xls]Feb2010'A3' .. something like this.. hm... I think unticking the option edit directly in cell .. will do the job.. but I really hope to get a macro.. well, I'm using 2007.. where is the option? can't seem to be able to locate it.. ^ ^;; I went throught all the options. On Tue, Mar 23, 2010 at 10:49 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. > -- ---------------------------------------------------------------------------------- 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.
