Hello,
I was hoping someone could give me a hand trying to figure out some code. I have a sheet within a workbook that pulls data from another sheet containing my companies bids on projects. It checks against records we have and adds the word "GAINED" to a column and highlights it red. Sheet is called "ALL":
On another sheet I have a bunch of data regarding each customer. In some columns I have the bid price broken up into volume, as a way to see what our pricing was like for that volume. That code is
What I would like to do is add to this code so it only gathers data from projects that have "GAINED" next to them. Any suggestions? Thanks!
By the way, this is the sheet named "GCDATABASE" that the code will be in:
I was hoping someone could give me a hand trying to figure out some code. I have a sheet within a workbook that pulls data from another sheet containing my companies bids on projects. It checks against records we have and adds the word "GAINED" to a column and highlights it red. Sheet is called "ALL":
HTML:
Excel 2007ABCDEGHIJK161Nov 12 2015North Fraser Tilt-Up8155 North Fraser WayBurnaby1,241 m3Bach Construction Ltd.$115.00GSDue:162Nov 16 2015The Westbourne1308 Fifth AveNew West2,700 m3Concost Management Inc$119.00GSDue:163Nov 19 2015Delta Hospital5800 Mountain View BlvdDelta m3Turn-KeyNQGSDue: 11/19/15 - No info on quote164Nov 20 2015Twassassen Commons SidewalksHwy 17 & 52 StDelta250 m3DFC Construction$135.00GS0165Nov 20 2015Bridge Studios3700 Henning DrBurnaby2,600 m3Prism Construction Ltd.$120.00GSDue: 11/19/15GAIN166Nov 23 2015Gabriola Park Townhomes20498 82 AveLangley1,299 m3Royale Properties$110.00GSDue: 11/24/15167Nov 25 2015Tilt-Up8155 North Fraser WayBurnaby1,241 m3Ram Construction Inc.$125.00GSDue: 11/25/15168Nov 27 2015Bayshore Ventures Multi-Tenant Building17690 65A AveSurrey2,000 m3Scott Construction$100.00GSDue: 11/27/15169Dec 01 2015Griffin Storage901 W 3rd StN. Van200 m3Prism Construction Ltd.$155.00GSDue: Now.On another sheet I have a bunch of data regarding each customer. In some columns I have the bid price broken up into volume, as a way to see what our pricing was like for that volume. That code is
Code:
=IFERROR(AVERAGEIFS(All!H:H,All!G:G,B2,All!E:E,">=1",All!E:E,"<=250"),0)What I would like to do is add to this code so it only gathers data from projects that have "GAINED" next to them. Any suggestions? Thanks!
By the way, this is the sheet named "GCDATABASE" that the code will be in:
HTML:
Excel 2007ABCDEFGHIJKLMNOPQRSUVWXY1Input NamesMaximizer NamesAddressAccount No.PhoneFaxContact 1Contact 1 NumberContact 1 EmailContact 2Contact 2 NumberContact 2 EmailContact 3Contact 3 NumberContact 3 EmailTotal BidsBids WonBids LostChance of Winning?10-250 m3250-2,000 m32,000-5,000 m35,000-10,000 m310,000 m3 +2AderaAdera Construction Ltd.PO Box 49214, Four Bentall CentreNone604-684-82771010%$0.00$0.00$135.00$0.00$0.003AsantiAsanti Development Limited2298 Kingsway113466091010%$0.00$0.00$0.00$0.00$0.004B&BB&B Heavy Civil Construction3077 188 Street3282396604-539-72002020%$135.00$135.00$0.00$0.00$0.005BachBach Construction Ltd.24280-66 Avenue3284404604-539-17941310377%$123.63$114.03$110.50$0.00$0.006BeedieBeedie Construction Ltd.3030 Gilmore Diversion, Burnaby3279907604-434-306624240100%$0.00$108.39$106.92$0.00$118.507BildxBildx Construction Inc931 Dennison Avenue17040853604-917-01550000%$0.00$0.00$0.00$0.00$0.00[CENTER][COLOR=#161120][B]GCDATABASE[/B][/COLOR][/CENTER]
Last edited:
