Sum up excel columns by Part #

Completato Pubblicato 5 anni fa Pagato alla consegna
Completato Pagato alla consegna

I have two separate excel sheets that I need data summed up. There is a quantity column and a Vendor Part number column. These represent each individual sale of a Vendor Part #. I need the quantity column totaled by Part #.

For example the spreadsheet Special Order Sales has the following items:

1 BMP3422068C

1 BMP3422068C

2 BMP3422068C

1 BMP3422068C

1 BMP3422068C

1 BMP3422068C

1 BMP3422068C

1 BMP3422068CSO

I want this to show up in a seperate tab as

7 BMP3422068C

1 BMP3422068CSO

If it could be done where I could collapse all of the items of each part number and just have a total row for each individual part #, that would be great.

I hope this makes sense. I believe it is a very simple project. I Just do not know the best way to do it and am wasting a lot of time trying to figure it out.

I will award this project based on price, of course, but also who can get it done immediately.

Inserimento Dati Elaborazione dati Excel

Rif. progetto: #18550426

Info sul progetto

11 proposte Progetto a distanza Attivo 5 anni fa

Assegnato a:

SBITServices

Hello Vinval, It is very simple task and i can sum up these with excel formulas. I have 5 years experience in advanced concepts like Pivot table, Vlookup, Charts, Data analyser etc. I never ask for payme Altro

$15 USD in 1 giorno
(441 valutazioni)
7.5
bhupendrayadav

I have more than 5 years of experience in advanced excel, VBA automation and data processing. I have successfully completed similar projects, please have a look at my portfolio for details. I can deliver this projec Altro

$15 USD in 1 giorno
(15 valutazioni)
4.0

11 freelance hanno fatto un'offerta media di $24 per questo lavoro

cgullapalli

HI, I am good at Excel and pivot tables. I see your requirement. I can summarize the data using pivot table quickly as required. Looking forward to work on this and provide quick turn around. -Chandra

$10 USD in 0 giorni
(802 valutazioni)
7.9
sergiuloghin

Hello! Ican resolve this using a VBA script. I can finish in 1-2 hours max. Thank you! I am ready to start now.

$30 USD in 0 giorni
(217 valutazioni)
7.5
saqibmunir55

sure i can do it right now sure i can do it right now sure i can do it right now sure i can do it right now

$20 USD in 1 giorno
(566 valutazioni)
7.3
TonmoyRoy111

Hello client I can do the task fast. I understand what is required to be done. Please contact mme. Roy

$25 USD in 0 giorni
(288 valutazioni)
6.6
lightingdavid

Hello? How are you? I have good experiences in "Sum up excel columns by Part #" as you can see my profile for these (Data Entry, Data Processing, Excel). I have been working for 7 yrs in this scope. While we contra Altro

$55 USD in 3 giorni
(14 valutazioni)
4.9
icatherinedivya

Hi I have written a lot of Python script to process any CSV/Excel fields. I can do this quickly. Please send me a message. You can check my reviews for more info. :) Thanks

$20 USD in 1 giorno
(13 valutazioni)
4.0
bskarthikas

Please give this work to me. Relevant Skills and Experience I am good in word and excel. So I can do this work with full accuracy

$25 USD in 1 giorno
(0 valutazioni)
0.0