| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
Info from one worksheet to another.
I'm new at this office, and they have a spread sheet with too much info in
too many places. What I want to do is have one worksheet w/ all sales info. Then have another worksheet that will auto populate by individual sales person. And then pull totals from both sheets to confirm correct numbers. How can this be done? Please feel free to email me for more info as well... thanks to anyone and everyone that could help on this!!! -- shannonk |
|
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
Info from one worksheet to another.
Try looking in the HELP it sounds like VLOOKUP ( HLOOKUP ) could be a choice
There are of course a multiple choice of formulae and/or macros you could use for this task. "Shannonk" wrote: I'm new at this office, and they have a spread sheet with too much info in too many places. What I want to do is have one worksheet w/ all sales info. Then have another worksheet that will auto populate by individual sales person. And then pull totals from both sheets to confirm correct numbers. How can this be done? Please feel free to email me for more info as well... thanks to anyone and everyone that could help on this!!! -- shannonk |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I get ONLY new info from 1 Worksheet to another automatical | Excel Worksheet Functions | |||
| import excel worksheet info to contact sub-folder | Excel Discussion (Misc queries) | |||
| show a block of info from a list on another worksheet | Excel Worksheet Functions | |||
| Delete ENTIRE row after updating info in worksheet. | Excel Worksheet Functions | |||
| Copy info from worksheet 1 to other sheets | Excel Worksheet Functions | |||
Linear Mode
