Pull a number from another spreadsheet
Hi guys
i need help please.
i am working on making a spreadhseet that automatically consolidates values from different spreadsheets.
how can i get a cell to find the max() from a range that is in another spreadsheet?
i need SpreadSheet1,Sheet1,A1 to display the MAX() of SpreadSheet2,Sheet1,D9:E99.
please help. thanks.
(no macros please)
i know it's possible to do with a formula.
Last edited by MastahFez; 03-06-2013 at 11:04 PM.
Hi.
Try this formula.I have considered D9:E14:
Please Login or Register to view this content.
Click *, if my suggestion helps you. Have a good day!!
this will not work for me, i need the formula to access a sheet from another spreadsheet.
thanks !
figured it out.
thanks !
=MAX('file location\[file name]sheet name'!cell numbers)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks