I have a workbook that I've created with 4 main worksheets. The first is a "logon" worksheet - the user selects a "path" to follow by clicking on one of the command buttons. (The purpose of the workbook is to dynamically create voucher sheets for expense reimbursement by project. Each project has its own workbook - each workbook has multiple worksheets.)
So far so good. BUT (user requirement) the user renames each worksheet. Of course, there is no main list of possible names - the user could name a worksheet 'INeedAStiffDrink' if desired. The user can NOT alter the layout of the worksheet however so all the sums for each sheet are always in G39, G40, and G41.
THEN I have a worksheet called Summary. And, you guessed it, this sheet needs to summarize all the data found in cells G39, G40, and G41 for all worksheets found within the workbook.
How do I do this since I don't know beforehand the names of the worksheets nor the number of worksheets in the workbook???
And yes, I know this would be easier in Access but that's not an option.
Thanks in advance. After reading through the forum listing I figure you guys will definitely have a way to do this!
Minthe
So far so good. BUT (user requirement) the user renames each worksheet. Of course, there is no main list of possible names - the user could name a worksheet 'INeedAStiffDrink' if desired. The user can NOT alter the layout of the worksheet however so all the sums for each sheet are always in G39, G40, and G41.
THEN I have a worksheet called Summary. And, you guessed it, this sheet needs to summarize all the data found in cells G39, G40, and G41 for all worksheets found within the workbook.
How do I do this since I don't know beforehand the names of the worksheets nor the number of worksheets in the workbook???
And yes, I know this would be easier in Access but that's not an option.
Thanks in advance. After reading through the forum listing I figure you guys will definitely have a way to do this!
Minthe