| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Compute using information from two different worksheets !
Hi,
I have one worksheet with total no. of prints, month and building wise, and I have another worksheet with head count also month and building wise. I need to compute on a new worksheet the Prints per head, month and building wise, by computing total/head count. Please can you give me a simple formula to be able to do that. I need the reply ASAP ! Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Compute using information from two different worksheets !
Copy/Paste all data onto one sheet and use a Pivot Table.
http://www.contextures.com/xlPivot02.html http://peltiertech.com/Excel/Pivots/pivottables.htm Regards, Ryan--- -- RyGuy "Shefali" wrote: Hi, I have one worksheet with total no. of prints, month and building wise, and I have another worksheet with head count also month and building wise. I need to compute on a new worksheet the Prints per head, month and building wise, by computing total/head count. Please can you give me a simple formula to be able to do that. I need the reply ASAP ! Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| gathering information from many worksheets | Excel Discussion (Misc queries) | |||
| information the same for cells on two different worksheets? | Excel Discussion (Misc queries) | |||
| VLOOKUP to pick information from two worksheets | Excel Worksheet Functions | |||
| How do I move information between worksheets? | Excel Worksheet Functions | |||
| Copying information from multiple worksheets into one | Excel Discussion (Misc queries) | |||
Linear Mode
