| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
dragging the row contents of all the sheet to a Index sheet
I have a workbook of sheets containeing Titles in a4 to i4 and its Values in
a5 to i5. I need to drag the a5 to i5 of all the sheets (1,2,3,4...200)to a "Index" sheet to make the Summery. Cell a1 to a5 is having same titeles of all the sheets. In the "Index" sheet, a5 of the sheet '1' will be in a2 and a5 of the sheet '2' will be in a3 if I drag. I do not know what is the right formula? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| transfer contents from a cell in previous sheet if the sheet is a | New Users to Excel | |||
| sheet dragging glitch? | Excel Discussion (Misc queries) | |||
| Excel worksheet - Can I make changes in one sheet affect contents of other sheet? | Excel Discussion (Misc queries) | |||
| Index/Contents Sheet | Excel Discussion (Misc queries) | |||
| Lookup cell contents in on sheet based on a formula in second sheet | Excel Worksheet Functions | |||
Threaded Mode
