Auto Data Input from a Closed File

  • Thread starter Thread starter rvalasho
  • Start date Start date
R

rvalasho

I want to import data from a closed Excel file into an active file. I
know Walkenbach developed the GETVALUE UDF for that purpose, but I
wonder if there are alternatives available.

My goal is to have a user select the data required from a drop down box
and that subsequently the correct data is imported into the correct
area in the active worksheet.

Thanks

Jack
 
Maybe you could have a hidden sheet with formulas that retrieve the values from
that closed workbook.

Then you could use Data|Validation and use the range on that worksheet as the
source of the list.
 
Back
Top