How to update an excel sheet dynamically from another excel sheet?

[Mona]

Lets say i have an excel sheet("daily report") opened in one book("Book1")
and another("monthly report") opened in another book("Book2"). How can i make
the "monthly report" to get updated dynamically while working in "daily
report".
For example, "Jack Simpson" has made a daily sale of 70 and his data is
saved in "Daily Sales", how can i update my "Monthly Report".What do i have
to do for that, please explain in detail.
Thanks

 

[Joel]

I s there a macro already running that saves the file into "Daily Sales"? If
there is a macro the best way is to modifiy the macro. If ther is a macro
can you paste the code?

 

[Gord Dibben]

See Excel help on "linking"


Gord Dibben MS Excel MVP

 

[FloMM2]

Mona,
You could link the two sheets.
Open "monthly report" and open "daily report" beside it.
Find the cell that you normally would update with the daily totals from
"daily report" on the "monthly report". For our example, say cell "B6" is the
total from the "daily report" for this day. On the "monthly report" sheet,
click in cell "B6" and type "=" ithout the "" in cell "B6", the on the "daily
report", find the cell with the total for today for our example, say it is in
cell "M37".
The cell "B6" on "monthly total" will change to "= daily report!$M$37"
without the "".
Now, in cell "M37" everytime cell "B6" changes, so will cell "M37".
hth
Dennis