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,

Kemahiran: Excel, Pemprosesan Data, Pemasukan Data, Visual Basic

Lihat lagi: 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

Tentang Majikan:
( 5 ulasan ) brooklyn, United States

ID Projek: #30154336

Dianugerahkan kepada:

(25 Ulasan)

46 pekerja bebas membida secara purata $120 untuk pekerjaan ini

(449 Ulasan)

(482 Ulasan)
(359 Ulasan)
(316 Ulasan)
(312 Ulasan)
(68 Ulasan)
(252 Ulasan)
(194 Ulasan)
(284 Ulasan)
(47 Ulasan)

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

$120 USD dalam sehari
(127 Ulasan)
(101 Ulasan)

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 Lagi

$70 USD dalam sehari
(41 Ulasan)

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!!

$30 USD dalam sehari
(21 Ulasan)

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 Lagi

$60 USD dalam sehari
(40 Ulasan)

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 Lagi

$80 USD dalam sehari
(25 Ulasan)

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 Lagi

$50 USD dalam sehari
(21 Ulasan)

✅ 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 Lagi

$65 USD dalam 3 hari
(7 Ulasan)
(3 Ulasan)

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 Lagi

$75 USD dalam 7 hari
(9 Ulasan)