| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy sales volume data from sheet 2 to sheet 1 by sales person
Sheet two has sales person and last month volume. Sheet one has sales person
and current volume. i want to find corresponding sales person on sheet 1 and copy the volume from sheet two. Any other way to do this besides a macro? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
copy sales volume data from sheet 2 to sheet 1 by sales person
VLOOKUP(), LOOKUP() and INDEX/MATCH are three ways that come to mind.
-- "Actually, I *am* a rocket scientist." -- JB (www.MadRocketScientist.com) Your feedback is appreciated, click YES if this post helped you. "pm" wrote: Sheet two has sales person and last month volume. Sheet one has sales person and current volume. i want to find corresponding sales person on sheet 1 and copy the volume from sheet two. Any other way to do this besides a macro? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating sales commission that changes based on a sales volume | Excel Worksheet Functions | |||
| How to Sum Up sales data by a product category from another sheet | Excel Worksheet Functions | |||
| How to Sum Up sales data by a product category from anther sheet | Excel Worksheet Functions | |||
| I need a daily sales sheet to pull from monthly figures sheet | Excel Worksheet Functions | |||
Linear Mode
