Thread: Importing data from another excel file automatically
View Single Post
  #5  
Old 03-05-2007, 10:21 PM
rondarat rondarat is offline
Registered User
  
Join Date: 04 Mar 2007
Posts: 6
rondarat is an unknown quantity at this point
Thanks for your help so far Duane!
I tried

=INDIRECT("C:\Documents and Settings\User\My Documents'["&E22&".xls]Sheet1'!E78")

Where E22 is where I enter the Ticket number (and I did a trial # that does exist) and E78 is the total from that ticket but it gives me '#REF!'-any suggestions?
Reply With Quote