Completed

Excel Macro (Data Pairing-Match-up)

We can provide a physical sample to freelancer, if required.

We need a solution that allows us to copy new data into a spreadsheet and run the macro. If special instructions are required to execute or prepare the macro, this is also expected.

Here’s the scoop:

We have a product inventory list whose ‘PRODUCTNO’ and ‘SKU’ are family, so to speak… in other words, they cannot be shuffled, if data were to be sorted, these two columns need to always be a ‘PAIR’, fair enough.

Our distribution center emails us daily, and sometimes weekly inventory data feeds that provide: both, ‘SKU’ and ‘QTY’ data to update our product list via a .csv file. In the inventory we need to add matching SKUs, as they are in different warehouses, but this does not affect what we need out QTY to show.

If the SKU is not in the INVQTYs, we need it to leave the existing quanity in shades.

We need to pair our product list -- to the inventory data feed .csv so that the ‘QTY’ data/columns will flow into our product list. The .csv data feed should reference the ’SKU’ in our Product List, and pair the ‘QTY’ data right beside it.

See Mock Up below: (FIG 1. product list, needs qty data from FIG 2. csv data file, based on matching sku numbers. Important: ‘PRODUCTNO’ assigned to the top skus, must not change.)

We need this macro for daily repetitive use, if this macro can be integrated into an excel spreadsheet, and emailed, that would be great since we will apply in new daily inventory data feeds. Also, we use Mac Office Excel 2008.

NOTE: The formatting of this text below was thrown off by the web processor. Please see the attached picture file for FIG 1 and FIG 2.

FIG 1. Product List:

PRODUCTNO SKU QTY

00000901 0001 0

00000902 0002 0

00000903 0003 0

00000904 0004 0

FIG 2. Inventory Data Feed:

SKU QTY

0001 56

0002 24

0003 14

0004 89

Evner: Dataindførsel, Databehandling, Excel, Lager Ledelse

Se mere: pairing data excel, excel macro matching data, pair data excel, data pairing, excel pairing macro, excel macro pair, excel pairing data, data pairing excel, excel pair data, excel macro data matching, pairing macro excel, pairing numbers excel, pair list skus excel, can pair data excel, macro matching data, excel inventory match, match update macro excel, inventory macro excel, match pair excel, excel data pairing

Om arbejdsgiveren:
( 1 bedømmelse ) 80022, United States

Projekt ID: #909989

Tildelt til:

mrbrave

See pmb please..

$85 USD på 1 dag
(65 bedømmelser)
5.3

2 freelancere byder i gennemsnit $123 på dette job

dataconsultants

Please check PMB for details, Thank you

$160 USD in 3 dage
(91 bedømmelser)
5.7