| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
auto creating an idex sheet when adding formatted sheets
I have a work book that has a no. of sheets fro sheet 2 to n no. no sheets
with similar format. The top row a1 to a10 has cells with heading . I add new this similar sheets continuously with changing data in b1 to b10. Now can I make sheet1 as index of those sheets and how to transfer pasting the contents of b1 to b10 data of every sheet into the row cells of sheet1 automatically as and when the sheets I add? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| adding sheets based upon a template sheet | Excel Worksheet Functions | |||
| creating multiple sheets, then individualized workbooks for each sheet | Excel Discussion (Misc queries) | |||
| Auto Fill Different Sheets same cell on each sheet? | Excel Discussion (Misc queries) | |||
| Pivot Chart/Sheet comparisons -- adding or subtracting sheets | Excel Discussion (Misc queries) | |||
| Auto link rows of information from multiple sheets to single sheet | Excel Discussion (Misc queries) | |||
Threaded Mode
