Populate array using data from another workbook

[xxnighthawkxx]

Hi all,

I am looking for a way to set up user input for file path

MyInput = InputBox("paste file path here")

Then using the file path entered here to select the sheet and column from that spreadsheet (sheet name and column will always stay the same only workbook name will change) and use that to populate an array which I can use in formulas in the excel sheet that launched the macro.

Can anyone help me out with this please?

[Bernie Deitrick]

You need to give us a little more info - what do you mean by "populate an array which I can use in formulas"? What array? What formulas?

Anyway, this will get you started selecting the workbook...

Please Login or Register  to view this content.

[xxnighthawkxx]

Thanks for the start,

for more information I need to pull the data into a look up array then use the =MATCH(C2,<array>)+1 function on the spreadsheet itself using a loopup array. looking at around 20,000 records.

[Bernie Deitrick]

Let's say that you want to fill cells D2:D??? with the formula to match the cells in column C:

Please Login or Register  to view this content.