Help Please

[singlgl1]

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

[Rowan]

One way you could do this without macros is to use the INDIRECT function.

In workbook "C" you could have the formula
=INDIRECT("["&A1&".xls]Sheet1!$B$5").
If you enter the name of the file you want to link to in A1 this will return
the value of cell B5 on Sheet1 in the workbook named in cell A1. To change
the file you want to link to you only have to change the name in cell A1.

Note: INDIRECT only works if the file you are referencing is open.

Hope this helps
Rowan

"singlgl1" wrote:

>
> 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
>
>