I am trying to find a way that will allow me to enter a value (that will
change daily) into a Master workbook that will populate cells in satellite
worksheets and workbooks. Leaving intact the prior days values in the
satellite sheets and books.


For example:
TotalPort.xls is the Master workbook and Schwab.xls is the satellite workbook
The daily value would be entered into Totalport.xls column cell F3
I would like that value to be populated to Schwab.xls column cell K500.
Leaving intact the prior days values in schwab.xls. The values by date will
be going in descending order.

I hope I have described this well enough for anyone willing to help with
this.

I am using winxp sp2 Excel 2003.

Thank you in advance for any help on this query.

Shred77

--
shredder