Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
get name of sheets
I am creating a simple envelope budgeting sheet. On my first sheet, I
would like to have a list of all the other sheets ('envelopes') and their balance. Each 'envelope' sheet has its current balance in cell A7 and I would like to access that as well. So my first sheet would have something like: 8 | 9 D <name of second sheet| value of A7 on second sheet E <name of third sheet | value of A7 on third sheet .... If possible, I would like this to be automatic so when I add another envelope sheet, its name and A7 value would show up on the first sheet. Finally, would it be possible to detect a double click on the sheet name and then switch to that sheet? Thanks in advance for any help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to update data from multiple sheets to one specific sheets | Excel Discussion (Misc queries) | |||
Multiple Sheets (Need to create 500 individual sheets in one workbook, pulling DATA | Excel Worksheet Functions | |||
How to repeat a code for selected sheets (or a contiguous range of sheets) in a Workbook? | Excel Worksheet Functions | |||
In 3 active sheets in wkbk, determine& display the # of sheets that have data | Excel Discussion (Misc queries) | |||
Allocate Files to Sheets and Build a Master Sheet which Summarises All Sheets | Excel Programming |