View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
kspurgin kspurgin is offline
external usenet poster
 
Posts: 1
Default input for external reference

I was wondering if there is a way to have an input for an external ref.
within my excel joblist.

i.e. set up of reference files
c:\jobs\011\index.xls
c:\jobs\012\index.xls
c:\jobs\013\index.xls
etc.
I want to have an option in a list to input the job# and then it references
that file:

a1 would be a user input of a job number, for instance someone can inout 011
and then b1:b10 would include info for c:\jobs\011\index.xls

Is there a way of having the reference include a1 in the name?