Want to get the totals off multiple sheets.
Posted by Curtis on July 20, 2000 8:45 AM
I have a problem. I have a workbook consisting of 2 sheets: Sheet1 and Totals. The user will key in figures on Sheet1 which are totaled at the bottom of the page. I have a button the user can click if he runs out of room on Sheet1 and have a blank copy of Sheet1 created thus making it Sheet2. So now we have 3 sheets: Sheet1, Sheet2 and Totals. Sheet2 is identical to Sheet1 except it's empty. Then the user can add figures into it(Sheet2)and they wll be sub-totaled at the bottom of it. The problem is how do I make my Totals page keep pulling the sub-totals off these sheets and totaling them on it? If I had a set number of sheets it wouldnt be hard but this workbook can sometimes only one sheet but up to 25. I want my totals sheet to pull the sub-totals off each sheet no matter how many I add. Please help. Thanks.