Linking to workbook filename by cell contents

  • Thread starter Thread starter jjs
  • Start date Start date
J

jjs

I'm linking to a sheet.
My sheet has contents A1 as input.
Let's say it's "John Smith"

In my sheed I need something like this in other cells.
='K:\[??.xls]Client1'$E$8
where "??" is the contents of cell A1 in my sheet.

I've messed with quoting and parens, concatenations but just can't noodle
out the syntax.

Many thanks in advance!
 
Back
Top