View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] edwrobis@uat.edu is offline
external usenet poster
 
Posts: 3
Default Making a Call to an external sheet using a variable...

Hello All

I am looking for a way to create a reference in my first document that
will be able to call to a variable document depending on a value in a
set cell.

So if the cell in document A is 10 then it will know to call document
name10.xls and if the value is 11 then it will call document
name11.xls...


Anyone have any ideas how this can be done?


Thanks!