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