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

Evner: Excel, Excel Macros, Excel VBA

Se mere: 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

Om arbejdsgiveren:
( 2 bedømmelser ) ATCHISON, United States

Projekt ID: #17578802

Tildelt til:


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 på 1 dag
(15 bedømmelser)

6 freelancere byder i gennemsnit $31 på dette 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, Flere

$55 USD på 1 dag
(14 bedømmelser)

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 Flere

$25 USD på 1 dag
(0 bedømmelser)
$15 USD på 1 dag
(0 bedømmelser)

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, Flere

$27 USD på 1 dag
(0 bedømmelser)
$25 USD på 1 dag
(0 bedømmelser)