S
SUMMARY SHEET AUTO UPDATE FROM WORKBOOKS
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
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