#1
|
|||
|
|||
Collate information using unique ID
Hi
Looking for some help I have two separate list I can export from another piece of software into excel, both list have a unique Quote No. List 1 has Quote No. - Sales persons name - Sell Price - Date List 2 has Quote No. - Costs (Which could be on several lines) I would like to output Each sales persons won job with sell price and cost for each month There are circa 300 won quotes per year and each quote could have circa 4 separate costs so this is a large manual task to do against the 10 Sales people. I have attached an example which I hope makes sense, my hope is to export the two lists into two separate sheets in a pre formatted excel sheet and have the figures calculated. I can calculate The total Value month by month for each Sales person for Accepted, Awaiting and declined but I cant work out how to get the costs over. Any help appreciated |
#2
|
|||
|
|||
There wasn't enough information about how those summaries are calculated, so I had to guess.
The CALCULATED tables on Sheet1 aren't in format meant for making calculations easy. I had to use my own design. |
#3
|
|||
|
|||
That is perfect!
Thanks for the speedy response |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Rolling Up Activities based on a Unique ID | OTPM | Project | 0 | 02-26-2018 04:55 AM |
Unique Random Numbers | PomDave | Excel | 1 | 01-12-2017 01:18 AM |
Indexed/Unique IDs | ID015 | Word VBA | 0 | 10-11-2016 03:15 AM |
message unique number | zemestan | Outlook | 1 | 10-20-2013 04:57 AM |
validation lookup with unique results | mark-gabb | Excel | 3 | 05-28-2013 08:39 AM |