| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
two worksheets, combine (merge data)
I hope I explain this clearly...
In Excel 2003, I have a workbook with two worksheets. (2006 and 2007 data) In worksheet one (2006): I have physican name and group and then total exams ordered The physican group is a subtotal field because I have several physicans that are practicing in the same group so I need that subtotaled which it is. So, I know Physican group "A" ordered 75 exams in 2006. I have worksheet two (2007) with the same set-up. What I want to do is pull the information from worksheet two so I can compare the year data in one worksheet. I thought I did this last year but cannot remember how I did it. Is there an easy way to achieve this? Thanks for your time. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to merge / combine several worksheets into one new worksheet without VBA / Macro? FOR EXPERTS | Excel Worksheet Functions | |||
| How do I combine data from 4 worksheets? | Excel Worksheet Functions | |||
| How do I merge or combine 2 excel worksheets by a common collumn? | Excel Worksheet Functions | |||
| Any way besides cut/paste to combine data in many worksheets (sam. | Excel Discussion (Misc queries) | |||
| Combine Data from 2 worksheets | Excel Discussion (Misc queries) | |||
Threaded Mode
