I’m trying to decide which is best, to create a macro (with some
assistance) or to just create links from cells to a new file. Here’s
what I have. I’ll be working with a new file; I’ll call “C”.
I need to link values from certain cells from file “A” and file “B”
into file “C”. File “A” contains a months worth of data, each day being
on a separate sheet.
File “B” contains data for only one day, and is saved as today’s date
each day.
The new File, “C” will incorporate data from each of these files and
will be saved daily also as today’s date.

In summary, I’ll be working with a new file actually called
Dailyproduction/08-16-05.This file will be saved each day using
subsequent dates as it’s file name.
This file will need info from cells in a file called
FieldProduction/Aug05, sheet16 , and will also need info from some
cells in a file called PlantProduction08-16-05
I’m a novice to macros. I’m wondering if I should simply create a
template with links to each cell from it’s connected file ,then do a
find/replace to change the links for the next days file, for example,
for the next day’s file, change the link from FieldProduction/Aug05,
sheet16 to FieldProduction/Aug05, sheet17 , etc.
Seems this would be the long way around but I’m drawing a blank with my
limited knowledge in Macros.
I’d appreciate the help-Greg


--
singlgl1
------------------------------------------------------------------------
singlgl1's Profile: http://www.excelforum.com/member.php...o&userid=26389
View this thread: http://www.excelforum.com/showthread...hreadid=396703