If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|