Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summary sheet auto update
i HAVE A SUMMARY WORKBOOK WHICH AUTO UPDATES FROM 3 OTHER WORKBOOKS. THESE 3
WORKBOOKS ARE LIVE DOCUMENTS AND WILL BE RE-SAVED CHANGING THE REVISION NUMBER ONLY. THE LOCATION WILL REMAIN THE SAME. MY SUMMARY CURRENTLY REFERS TO EACH WORKBOOK AND BRINGS BACK THE DATA I REQUIRE. HOWEVER, HOW CAN I GET THE SUMMARY TO FETCH THE SAME REVISED DATA FROM THE 3 WORKBOOKS WHEN THEY HAVE BEEN RESAVED WITH A DIFFERENT REVISON NUMBER? IN SHORT - SUMMARY READS FROM WORK BOOKS 1,2,3 v11. ONCE THEY HAVE BEEN RESAVED I NEED IT TO AUTOMATICALLY UPDATE FROM WORKS BOOKS 1,2,3 v12 WITH MINIMAL EFFORT. IS THERE SOME KIND OF LINK THAT I CAN PUT IN THE SUMMARY SO ALL I HAVE TO DO IS CHANGE THE NAME OF THE FILE TO LOOK FOR? THANKS FOR YOUR TIME ON THIS JAYNE |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Update Summary Sheet Automatically | Excel Discussion (Misc queries) | |||
how do I update the scenario summary sheet? | Excel Worksheet Functions | |||
I need a payroll sheet that can auto update figures each week | Excel Worksheet Functions | |||
auto file path update when excel sheet moved to another directory. | Excel Discussion (Misc queries) | |||
Auto Update Sheet Tab | Excel Worksheet Functions |