| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automate sheets list
Hi to all,
I have been looking on how to get this through. I have a workbook with at least 3 sheets, that can increase to 20, 30, etc... or reduced to 3. the first 3 sheets are always in the workbook, as standard. The thing is that in the second sheet i want to list all the sheets present in the workbook, as a list, and next to each one I want the value in cell H12. Ie.: Sheet name - total (cell H11 of each sheet) Assy1 3.4341 Mech1 11.24508 ..... mech5 3.7654 Patt 12.6667 Can any of you give some help/clue how to get this done? Thanks in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| automate adding sheets | Excel Discussion (Misc queries) | |||
| List Sheets excluding sheets named ***-A | Excel Discussion (Misc queries) | |||
| automate formating a mailing list | Excel Discussion (Misc queries) | |||
| automate creation of sheets in excel | Excel Worksheet Functions | |||
| I would like to know how to automate graph using drop down list | Charts and Charting in Excel | |||
Threaded Mode
