Referencing to worbooks with dates in the worbooktitle

kterkuile

New Member
Joined
Dec 10, 2009
Messages
34
Hi all,

I have a worksheet that i copy production data in. Each production process is in a row and in the columns i have the production of each day of the week and some derivate functions as 'in stock' etc. The production is for each calendar date.

The data are in a sheet that i get every day. The sheet is always of the same structure with -of course- different production values. The dataworkbook contains one sheet and has the same structure as my main workbook. Every day i get the datasheet via mail and it always has the same name.

I want to make formulas in the cells in my main where the data from the dataworkbook should be pasted. I want to make a formula which references to the dates on top of the columns and that recognizes a date reference in the dataworkbooks. The name of a dataworkbook will be something along the lines of '20100419productiondata.xls'. So the formula should look for the date on top of the column in the mainworkbook, compare that to the date in all the names of all the dataworkbooks and then refer to the right cell. Now, referring to the specific cells i can do, but referring from the formula to the filename is far beyond me. Could anyone help me please?

Take care,

Kaerel
 

Some videos you may like

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.

Watch MrExcel Video

Forum statistics

Threads
1,095,361
Messages
5,444,020
Members
405,260
Latest member
Khauff

This Week's Hot Topics

Top