Ok what i need to do is have a formula in one sheet that will use information from a given cell on another sheet. These sheets are in the same workbook. Is this possible. If so, how? Thanks
Ok what i need to do is have a formula in one sheet that will use information from a given cell on another sheet. These sheets are in the same workbook. Is this possible. If so, how? Thanks
Last edited by jon@karhu; 11-07-2008 at 01:16 PM.
Try this.
-Type "=" (without the quotes)
-Click on the other sheet tab
-Click on the specified cell
-Hit Enter.
This should show you the basic format on how to reference other worksheets in formulas.
HTH
Jason
Yes thats great. Thank you very much. Hard to beleive it was that easy.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks