| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
how can you view cells from different worksheets in to one sheet,.
hi,
I have multiple worksheets, more than 200 of them, and i wanted to summarize some cells in to one sheet, I know how to do it by entering the code manually (='7'!$D2), this shows cell d2 in sheet 7, but is there a function to do that like drag or something? |
|
#2
|
|||
|
|||
|
You can use this macro myasin
http://www.rondebruin.nl/summary.htm -- Regards Ron de Bruin http://www.rondebruin.nl "myasin" wrote in message ... hi, I have multiple worksheets, more than 200 of them, and i wanted to summarize some cells in to one sheet, I know how to do it by entering the code manually (='7'!$D2), this shows cell d2 in sheet 7, but is there a function to do that like drag or something? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| view list of worksheets contained within a workbook | Excel Worksheet Functions | |||
| copying cells from other worksheets | Excel Discussion (Misc queries) | |||
| adding certain cells in multiple worksheets in multiple workbooks | Excel Worksheet Functions | |||
| Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
| How to view tiled Excel worksheets by locking rows for scrolling . | Excel Worksheet Functions | |||
Linear Mode
