| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple Sheets
I have multiple worksheets in a workbook. I would like to copy the same
row/cell from each worksheet to a matching column on the main worksheet. (ie: The summary/main page has a column listing the names of the worksheets. In adjacent column, we want to copy a particular cell for the corresponding sheet) I need to "lock" the cell and have the worksheet title as my variable. Can this be done so we don't have to enter ='sheetname'$cell for each? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automated multiple text files into multiple sheets in one workbook | Excel Discussion (Misc queries) | |||
| Lookup using multiple sheets and multiple criteria, sorry if 2 pos | Excel Worksheet Functions | |||
| Multiple Sheets (Need to create 500 individual sheets in one workbook, pulling DATA | Excel Worksheet Functions | |||
| How do i auto create multiple files from 1 with multiple sheets | Excel Worksheet Functions | |||
| Exporting multiple sheets to multiple htm files? | Excel Discussion (Misc queries) | |||
Threaded Mode
