Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to update an excel sheet dynamically from another excel sheet?
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to update an excel sheet dynamically from another excel sheet?
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? "Mona" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to update an excel sheet dynamically from another excel sheet?
See Excel help on "linking"
Gord Dibben MS Excel MVP On Sat, 12 Jul 2008 06:31:00 -0700, Mona wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to update an excel sheet dynamically from another excel sheet?
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 "Mona" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to update an external excel sheet | Excel Discussion (Misc queries) | |||
How to update an external excel sheet | Excel Worksheet Functions | |||
Transfer/Copy Sheet, Dynamically linked Sheet | Excel Discussion (Misc queries) | |||
creating a combobox dynamically on an excel sheet | New Users to Excel | |||
how to update functions in excel sheet? | Excel Worksheet Functions |