Populate a changing daily value to other workbooks and sheets

[shred77]

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

 

[carlo]

Hi Shred77

In schwab.xls will it always be K500?
then:Schwab.xls cell K500 holds this formula
=TotalPort.xls!Sheet1!F3

If today will be K500 and tomorrow K501
you will need to do that with VBA.
In totalport.xls:
open the workbook "schwab.xls"
enter the value
close the workbook
go to next satelliteworkbook.

hth

Carlo

 

[shred77]

Hi Carlo,
Thanks for the response. No, the daily price will keep moving down the
column to K501 K502 etc... My hope is to be able to enter the price once and
have it populate all the other workbooks and worksheets.
So it sounds like VBA is the only way for this then?

 

[carlo]

Hi Carlo,
Thanks for the response. No, the daily price will keep moving down the
column to K501 K502 etc... My hope is to be able to enter the price once and
have it populate all the other workbooks and worksheets.
So it sounds like VBA is the only way for this then?
--
shredder







- Show quoted text -

Yeah, at least I know of no other solution.
Because Formulas can only get values and not push them.

If you need help with the VBA, post your questions.

Carlo