Hi,

I have a list of data contained in a series of files stored on a network.
There is one file for every month, ( file name Jan, feb etc). Each file has
31 sheets (sheet names 1,2,3 etc) to record certain events every day of the
month. Some days may be empty and have nothing written.

There is then another file which I would like to fill automatically from
this series of files per month. This new file, called Summary in which i
have 5 sheets (a,b,c,d,e). I would like to find a way of automatically
copying data
from - Jan/1 cells d12, e12 & m12
to - Summary/a cells f2, g2 & d2 (row 2 to is for 1 Jan)

The next day, Jan 2 i need to take the data from Jan/2 cells d12, e12 & m12
and copy to summary/a cells f3, g3 & d3 (row 3 is for 2 Jan).

So basically I need a way of searching through a network by date to take
data from a certain folder and sheet to copy into a corresponding row by date
in another folder.

Is this possible?

Ron de Bruin has tons of sample code he
http://www.rondebruin.nl/tips.htm
Look for: Copy/Paste/Merge examples


LiAD wrote:

Hi,

I have a list of data contained in a series of files stored on a network.
There is one file for every month, ( file name Jan, feb etc). Each file has
31 sheets (sheet names 1,2,3 etc) to record certain events every day of the
month. Some days may be empty and have nothing written.

There is then another file which I would like to fill automatically from
this series of files per month. This new file, called Summary in which i
have 5 sheets (a,b,c,d,e). I would like to find a way of automatically
copying data
from - Jan/1 cells d12, e12 & m12
to - Summary/a cells f2, g2 & d2 (row 2 to is for 1 Jan)

The next day, Jan 2 i need to take the data from Jan/2 cells d12, e12 & m12
and copy to summary/a cells f3, g3 & d3 (row 3 is for 2 Jan).

So basically I need a way of searching through a network by date to take
data from a certain folder and sheet to copy into a corresponding row by date
in another folder.

Is this possible?

--

Dave Peterson