ISO Excell Expert

I have this clerking sheet that i have been using, and i have tried using pivot tables, but i can not get the information to show like i need it to. the line # is the number we assign the the item won (col a), consignor (column B) bid and qty, then who it was sold to. i want to consolidate buyers purchases. for example in the sheet attached, frank bought more that on thing, and i would like that to show up in a table, telling me what frank bought, with a total amount due. I would also like a consignors report of what consignor sold what.

My next "want" for this sheet... is i have an area at the top of clerk sheet where i enter the data, for current item being bid on. i fill it out hit enter, and it populates below and keeps a running tab of everything i enter.

I've spent a few weeks trying to figure it out and i fold. i have an example sheet of what data i need drawn into groups

Skills: Excel, Excel Macros, Excel VBA

See more: specialized big hit expert, html table dynamic total, word table convert excell, excel expert tutorial, become an expert in excel, how to be expert in excel formula, how to become expert in excel pdf, expert coders outsourcing groups list, table css template status report, javascript calculate table column total, convert word table excell, add groups jos_core_acl_aro_groups table set relations correctly, convert word chart excell table, div table expert, joomla insert excell table article, pivot table hit ratio, thing required prepare company annual report, write table excell sheet, excell expert, i need an expert in english language that would help to grade my essay test

About the Employer:
( 2 reviews ) ATCHISON, United States

Project ID: #17578802

Awarded to:


i have good command over Ms excel especially pivot table, charts, advance formulas, formatting, macro etc. Please contact with me for [login to view URL]

$40 USD in 1 day
(15 Reviews)

6 freelancers are bidding on average $31 for this job


Hi, I am a chemical engineer and I have over five years experience in using Excel at an advanced level (complex formulas, array formulas, pivot table and charts, macros and VBA scripts, automatic calculation sheets, More

$55 USD in 1 day
(14 Reviews)

Hello, I have despicable past experience and excellent work record with regards to making dashboards in PowerBI, Tableau, Sisence and other BI Tools. I have developed several Dashboards and I am ready to show some pas More

$25 USD in 1 day
(0 Reviews)
$15 USD in 1 day
(0 Reviews)

I have been working with excel for the past 12+ years in a corporate environment. I am quick, reliable, and have an ability to communicate data well to the end user. I am known for creating user friendly excel reports, More

$27 USD in 1 day
(0 Reviews)
$25 USD in 1 day
(0 Reviews)