I would like to link a page from one workbook to another
I would like to link a page from one workbook to another
What do you mean?
I have one book that i keep summarys in and 18 data pages I would one of the data pages to anopther workbook that contains the results page
Using Insert>Hyperlink>Link to file
Something like this:
Not sure if this is what you are looking for or not.Workbooks.Open Filename:= _ "C:\Folder\filename.xls"
Peace of mind is found in some of the strangest places.
I want the cells to link to a page in another book
Don't worry I figured it out. I was just being blind.