En curso

Build Excel Template for Stock Management

Dear,

Every day we export new customers orders in Excel from our 3 e-commerce sites.

The product references are the same for the 3 sites.

We want to extract products references and quantities to one new document to know what we have to order to suppliers in one time.

=> So from our export:

Excel tab 1: - Site I -

product 002 x3

product 002 x1

product 007 x1

product 009 x2

Excel tab 2: - Site II -

product 001 x1

product 009 x1

Excel tab 3: - Site III -

product 007 x4

product 009 x5

product 007 x1

=> We want an automatic Excel formula to have this:

TOTAL PRODUCTS:

product 001 x1

product 002 x4

product 007 x6

product 009 x8

Do you understand our need, can you help us?

Habilidades: Excel, Visual Basic

Ver más:

Información del empleador:
( 108 comentarios ) Phuket, Thailand

ID de proyecto: #9766567

Adjudicado a:

mrfarhanzahid

Dear Sir, I am a MBA student with strong grip on MS Excel. Working in excel is part of our routine, I have handled data of more than 3000 entries, worked on stock analysis, developed operational model for a satellite Más

$15 USD en 1 día
(2 comentarios)
1.2

13 los freelancers están ofertando un promedio de $45 para este trabajo.

$20 USD en 0 días
(308 comentarios)
7.5
mantislin

Hi sir, I am scraping expert, I have did too many similar projects, please check my feedback then you will know. Can you tell me more details? then I will provide demo data for you. Thanks, Kimi

$250 USD en 5 días
(58 comentarios)
6.0
Tanmoy236

I am extremely good with excel as it is part of my daily professional work. I have already done 35 works on Freelancer where I got all 5 star rating and the employer was extremely happy with my work. I believe I can do Más

$30 USD en 1 día
(18 comentarios)
4.0
VinayOnTask

Hi there, I’d like to be considered for your bid. I am a software developer with a strong background developing excel, access related applications, including excel functions,active x objects, sql server as backend, dat Más

$35 USD en 3 días
(5 comentarios)
2.6
Imelda7s

Hi, I have great excel skills. please send in the exports that need to be worked on. thanka

$20 USD en 1 día
(1 comentario)
0.6
babuplrk

Hello I have carefully gone through your job description and am very much interested in this task. I am well in visual basic. Looking forward.

$30 USD en 1 día
(0 comentarios)
0.0
TianaKay

Local Australian with extensive excel/vba experience in an reporting and analytics. Ive worked as an operations analyst at some of the biggest ecommerce companies in aus/globally (eBay, Groupon) creating automated solu Más

$55 USD en 0 días
(0 comentarios)
0.0
vp88200

i know this type of work consider very important point like grammer, paragraph, preposition,accuracy, proper time to order i can do your work nicely and complete only in 7days. if you want to take my test so i am Más

$35 USD en 7 días
(0 comentarios)
0.0
AbiSag90

Hi! I can make a document with the specifications you need. The document will include a table where you put the products's quantities you need. And in the next sheet a resume of the total products. I hope you conta Más

$20 USD en 1 día
(0 comentarios)
0.0
$20 USD en 1 día
(0 comentarios)
0.0
GaryX

A proposal has not yet been provided

$35 USD en 2 días
(0 comentarios)
0.0
$25 USD en 1 día
(0 comentarios)
0.0