Lookup and pull data from all workbooks of a folder; transfer to a target workbook

**Silver.blue** · 04-02-2011, 09:18 AM

Dear All,

I am so happy to have found this cool place,

I am new to macros, and I am struggling to implement the below:

I will need to vlookup and pull data from standard workbooks that will be saved in the same folder monthly; (attachment in my third post, sample Sales_Stats_201105) to a target workbook. The data will be pulled from a vertical table {Pears, Apples, Olives} with n columns

The target workbook contains a column of text data (eg {Pears, Apples, Olives})

I have implemented a vlookup formula, returning the value of a single cell (e.g =VLOOKUP($A25,'[Sales_201105.xls]Grocery'!$A29:$J46,COLUMN(B$25),FALSE))

I would like to be able to run a macro instead, that will vlookup and populate the relevant cells of the target spreadsheet;

I thank you very much in advance and very much appreciate your efforts

Greets
Silverblue

**nimrod** · 04-02-2011, 06:55 PM

Maybe a upload sample of a source and target book would be a good idea. Upload to the thread can be done through the "Go Advanced" button.

**Silver.blue** · 04-03-2011, 05:27 AM

Hello and many thank,

The target book should be KPI Sales; The source book is Sales_stats_201105 - the source books will be saved in the same folder, each month, these will be standard;