getting data for many files from one file
 

Here is what i am having a problem with . I have a folder with about
150 excel files. each file is a reperesents a company. I have to
update about 12 cells in all 150 files every month. I am getting the
data for these 12 cells from 2 different workbooks, we can call these
books "input data" to make things easier to understand.

what i do currently is consolidate the sheets from the "input data"
workbooks into one workbook and create a pivot table only showing me
the company name and only the 12 fields that i am looking for.

then i open the 150 excel files one by one and keep switiching back
from and to the pivot table to populate the data.
This process is driving me crazy.

The vlookup feature will NOT work for me because every month this data
has to be filled out in a different location in the 150 files.
different row for change in month.

can anyone suggest a better workflow or an automated process that will
help me make this process more efficient.

Thanks guys

getting data for many files from one file
 

Hi ?

See this example page
http://www.rondebruin.nl/copy4.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


wrote in message oups.com...
Here is what i am having a problem with . I have a folder with about
150 excel files. each file is a reperesents a company. I have to
update about 12 cells in all 150 files every month. I am getting the
data for these 12 cells from 2 different workbooks, we can call these
books "input data" to make things easier to understand.

what i do currently is consolidate the sheets from the "input data"
workbooks into one workbook and create a pivot table only showing me
the company name and only the 12 fields that i am looking for.

then i open the 150 excel files one by one and keep switiching back
from and to the pivot table to populate the data.
This process is driving me crazy.

The vlookup feature will NOT work for me because every month this data
has to be filled out in a different location in the 150 files.
different row for change in month.

can anyone suggest a better workflow or an automated process that will
help me make this process more efficient.

Thanks guys