ISO Excell Expert

$10-30 USD

Завершено

Опублікований

over 5 years ago

$10-30 USD

Оплачується при отриманні

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

Excel

Excel Macros

Excel VBA

ID проекту: 17578802

Про проект

6 пропозицій(-ї)

Дистанційний проект

Активність 6 yrs ago

Хочете заробити?

Переваги подання заявок на Freelancer

Вкажіть свій бюджет та терміни

Отримайте гроші за свою роботу

Опишіть свою пропозицію

Реєстрація та подання заявок у проекти є безкоштовними

Доручений:

@haleem0786

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 за 1 день

4,9

(15 відгуки(-ів))

3,6

6 фрілансерів(-и) готові виконати цю роботу у середньому за $31 USD

@afenache

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, automatic simulators and charts drawing) as an Industrial Engineer at Michelin Romania. I am always keen to improve my work quality and productivity and, to achieve these goals, I made complex Excel sheets to automate my tasks and eliminate errors. I will be glad to help you with your project and I am sure you will be satisfied with my professionalism and the quality of my work. Best regards, Florin Enache.

$55 USD за 1 день

5,0

(14 відгуки(-ів))

4,1

@otweyo

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 past samples that I developed. I have excellent time management skills and I am ready to negotiate to accept a lower price. Kindly reply my request. Thank you

$25 USD за 1 день

0,0

(0 відгуки(-ів))

0,0

@jdtcj5

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, and tight, concise, efficient returns of data.

$27 USD за 1 день