Chooseing file to pull data

[Adrac]

Hello All,

I have a formulated table and over 100 workbooks with different names.
I would like a macro that will let me pick an individual workbook and pull data from it into a master workbook.

Can anyone help?

Adrac

 

[Legacy 143009]

If I were you I would use a formula.

1.First make a new sheet and list the work book names in Column A (and sheets names If you want)
2.Then come to your main sheet and select a cell for data verification. Let it is D1. Make a verified list of just workbook names for now. Sheet name will always remain 'Sheet1'.
3.Then use INDIRECT function in your formulas. Lets keep it simple. For instance you want to add 5 to add value to a external value.

=[Budget.xlsx]Sheet1!A1+5

will become

=INDIRECT(D1&"Sheet1!A1")+5

After all whenever you pich a workbook name from the list created in D1, the values will be updated. I hope this would give an idea.

 

[Adrac]

Hello Flash,

Yes thank you this has given me an idea on how I can achieve this with the formula you have provided.

Thanks again.