| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Over laying combined data?
I have years of sales history in 3 different work sheets and I woul like to
overlay them so that I can look at each company for a 3 year period. I need to do this while not repeating customer names and knowing thatsome customers are not on all lists? Any help? |
|
#2
|
|||
|
|||
|
Hi Zane. Would it be possible to create a 4th sheet with all your customer
names and use VLOOKUP on the other 3 sheets to draw in the information into the 4th? -- Sincerely, Michael Colvin "Zane" wrote: I have years of sales history in 3 different work sheets and I woul like to overlay them so that I can look at each company for a 3 year period. I need to do this while not repeating customer names and knowing thatsome customers are not on all lists? Any help? |
|
#3
|
|||
|
|||
|
Michael,
Thanks for your suggestion I will try this and let you know. "Michael" wrote: Hi Zane. Would it be possible to create a 4th sheet with all your customer names and use VLOOKUP on the other 3 sheets to draw in the information into the 4th? -- Sincerely, Michael Colvin "Zane" wrote: I have years of sales history in 3 different work sheets and I woul like to overlay them so that I can look at each company for a 3 year period. I need to do this while not repeating customer names and knowing thatsome customers are not on all lists? Any help? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to search for and display data in another worksheet | Excel Worksheet Functions | |||
| Reference multiple cells in if statement | Excel Worksheet Functions | |||
| Import Data Keeps asking for Password | Excel Discussion (Misc queries) | |||
| Copying conditional formatting...HELP PLEASE!!!! | Excel Worksheet Functions | |||
| Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) | |||
Linear Mode
