Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-11-2019, 06:51 AM
CarlosTJ CarlosTJ is offline Collate information using unique ID Windows 10 Collate information using unique ID Office 2016
Novice
Collate information using unique ID
 
Join Date: Feb 2019
Posts: 2
CarlosTJ is on a distinguished road
Default 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
Attached Files
File Type: xlsx EXAMPLE.xlsx (13.3 KB, 10 views)
Reply With Quote
  #2  
Old 02-11-2019, 08:26 AM
ArviLaanemets ArviLaanemets is offline Collate information using unique ID Windows 8 Collate information using unique ID Office 2016
Expert
 
Join Date: May 2017
Posts: 869
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

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.
Attached Files
File Type: xlsx CostAndPrice.xlsx (21.5 KB, 9 views)
Reply With Quote
  #3  
Old 02-11-2019, 10:28 AM
CarlosTJ CarlosTJ is offline Collate information using unique ID Windows 10 Collate information using unique ID Office 2016
Novice
Collate information using unique ID
 
Join Date: Feb 2019
Posts: 2
CarlosTJ is on a distinguished road
Default

That is perfect!
Thanks for the speedy response
Reply With Quote
Reply

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
Collate information using unique ID 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
Collate information using unique ID 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

Other Forums: Access Forums

All times are GMT -7. The time now is 11:15 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft