Thread: Importing data from another excel file automatically
View Single Post
  #10  
Old 03-07-2007, 11:54 PM
rondarat rondarat is offline
Registered User
  
Join Date: 04 Mar 2007
Posts: 6
rondarat is an unknown quantity at this point
Played with it some more and this is what it gave me when I closed the source file

='C:\Documents and Settings\User\My Documents\[4126.xls]Sheet1'!$E$78

How do I get the '4126' to come from what I input into cell E22? I tried the "&E22&" that you suggested earlier and it gave me the dreaded #REF! again.
Reply With Quote