Tamamlanmış

Excel Macro Sheet

I have an inventory sheet that I need to be figured out. I know that outcome is needed, but I want someone to give me some better ideas on how to design and construct the sheet.

Attached is the sheet with some instructions.

The work is needed on the first 3 sheets, the last 4 sheets are here to provide you with the data needed.

The fields to fill with formulas are highlighted in yellow.

We sell on several websites, and on my sheets, A marketplace listing is called "Store SKU". Every Store SKU is mapped to an internal Item Number of our internal catalog, we do have a "MAPPING" that will tell you what is the item number for each store SKU.

Basically, this is an ordering sheet, that the buyer will make a note how much to order for a "Store SKU", i need the sheet to do the following jobs:

A) Import "warehouse" stock into "Working sheet" so the buyer can see if the item is available in any of our warehouses.

B) Generate an order to place from the vendor - but in this order, the item number have to be unique, meaning if the item number is ordered for a few different "Store SKU"s, it should only show once on the PO sheet, with the total QTY

C) Generate a "Shipment" in the shipment sheet, using the "Store SKU" or listing ID.

Let me know if you can work with these, and your cost would be - If we agree, I will provide you with more detailed instructions.

If you would like to give it a shot we can get into more details, so I can explain everything better.

Let me know your initial thoughts.

Thank You,

Beceriler: Excel, Veri İşleme, Veri Girişi, Visual Basic

Daha fazlasını gör: excel macro filling excel sheet, excel sheet inventory stationary, excel macro list worksheet names sheet, excel multi sheet example inventory, sample excel sheet inventory net change, excel macro web query cell sheet, excel macro sum column sheet, read sheet name excel macro, word excel macro sheet, excel macro print sheet, excel vba run sheet macro sheet, cut paste protected sheet excel macro, excel macro copy next sheet, excel macro print specific page sheet, excel macro stock inventory, excel macro update inventory prices, excel macro based inventory control system

İşveren Hakkında:
( 5 değerlendirme ) brooklyn, United States

Proje NO: #30154336

Seçilen:

(25 Değerlendirme)
4.6

Bu iş için 46 freelancer ortalamada $120 teklif veriyor

(449 Değerlendirme)
8.3
P0L

(482 Değerlendirme)
8.0
(359 Değerlendirme)
8.0
(316 Değerlendirme)
7.1
(312 Değerlendirme)
7.4
(68 Değerlendirme)
6.9
(252 Değerlendirme)
6.9
(194 Değerlendirme)
6.6
(284 Değerlendirme)
6.4
(47 Değerlendirme)
6.4
writingapp

Hi. I have written many automation Excel VBA macros. Ready to write your project. Will complete within some hours

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(127 Değerlendirme)
6.1
(101 Değerlendirme)
5.7
yadavexpert53

Dear Employers, I can assist you in “Excel Macro Sheet” the best way & according to your project need. I am an expert and professional in MS Excel Formulas & VBA (Automation by macros). Pivot Tables, Data Scrapping fro Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(41 Değerlendirme)
4.8
utkarsh7238

Hey, I can give you some better ideas on how to design and construct the sheet What is your Deadline?? Let's Talk upon your project Waiting for your response!!

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(21 Değerlendirme)
4.6
mowachira77

Hi there, I have fully reviewed your work details and am ready to work on it. I will create an excel sheet that will constantly update the inventory from warehouse's to excels. Then the sheet will make and fulfill an o Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(40 Değerlendirme)
4.8
MonisZafar

Hello, I've read your project requirements thoroughly. It's quite an easy task and I can achieve this through a VBA script. It will be quick and accurate. I will start right away and complete it within a few hours. If Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(25 Değerlendirme)
4.9
borispetrovfrl

Hello, Sir. Expert of Excel VBA is here. I've gone through your project requirement and found my skill best suited in this one. I am familiar with technologies such as C++, VB, MS Office, Database Programming, Data Pro Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(21 Değerlendirme)
4.1
abnasif

✅ QUALITY FIRST Hi there, I have read your description and I can do exactly what you are looking for. I have checked your required job A, B and C. I have been working as reporting engineer and used to handle big excel Daha Fazla

$65 USD in 3 gün içinde
(7 Değerlendirme)
3.4
(3 Değerlendirme)
3.5
dicadio

Dear SIr, I understood the requirement , i can generate automatically with you want , and other solution for make it's correct . I have experienced in macro VBA , or i can use python script to read and process it . i Daha Fazla

$75 USD in 7 gün içinde
(9 Değerlendirme)
3.4