| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Create a "recap" worksheet that includes all info from all worksh.
I need to recap all information from all worksheets on one worksheet. How is
the best way to accomplish this? Is it best to put the info first into the all-inclusive worksheet and then use a formula on each individual worksheet to pull certain information? |
|
#2
|
|||
|
|||
|
hi,
i think it would be best to put formula on the recap sheet to pull the needed information from the other sheets. fomula's like =(sheet2!A1) will return the contents of cell A1 on sheete2 =sum(sheet2!a1:a10) will sum the range A1:A10 on sheet2 -----Original Message----- I need to recap all information from all worksheets on one worksheet. How is the best way to accomplish this? Is it best to put the info first into the all-inclusive worksheet and then use a formula on each individual worksheet to pull certain information? . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| When updating a worksheet, how do I create a link updating the sa. | Excel Worksheet Functions | |||
| Can one still create a graph using data in the worksheet? | Excel Worksheet Functions | |||
| How do I give all access to one worksheet but not to other worksh. | Excel Worksheet Functions | |||
| AUTOMATICALLY REFERENCE SALES INFO FROM WORKSHEET #1 INTO INDIVID. | Excel Worksheet Functions | |||
| How do I create a total sheet that will pull info from all my she. | Excel Worksheet Functions | |||
Linear Mode
