Fermé

StockLocator

Utility description

Need a Excel VBA to create and compare a list of stock with location and quantity data, from barcode scanned items in store / warehouse location.

The list will be imported into a stock control program called Unleashed, to update the location & quantity of stock.

The unique field will be the scanned barcode. The user will input a location, and scan the barcodes of the items in that location ( Multiple items, of multiple different types of items can exist at one location). Then repeat the process for another location. The list will be created & updated in excel, and used to Import data to Unleashed.

If stock data is already present in Unleashed, to start the process an export is taken from Unleashed and imported to Excel.

In excel, user will open VBA utility and enter location data in the format of a warehouse code or store code ( see Location examples below ).

Location data entered will be retained and used for subsequent barcodes scanned, until it is changed by the user. Barcodes will be scanned by user, and optionally a quantity entered for each. Excel list will be searched for matching barcode. If not found and quantity data has not been entered, it will be prompted for. The barcode, location and quantity data will be added to the list. If found location data will be updated, quantity data will be overwritten if it has been entered by the user. Quantity data will not be changed if not entered by user. Location data will be updated as follows.

If no existing data is present, the field is populated with location data previously entered by user. If location data is present the data type is compared to that entered. If not found the data is saved. It is prepended to store data if that is present and it is warehouse data. It is appended to warehouse data if that is present, and it is store data. If data is present of the type being entered, the location is updated, without changing data of the other type if that is present. For example, if the location field contains warehouse location data, and warehouse location data has been entered it will be updated, without changing store location if that is present.

Once user completes update of list, it is imported to Unleashed. Overwriting the Unleashed data.

‘Location’ field in excel corresponds to ‘Bin Location’ in Unleashed and can contain two types of data, a warehouse code and a store code. Therefore the combinations for the field are, nothing / warehouse data / store data / warehouse and store data.

Warehouse code format is Ann-Bn-Sn. Store code format is AAA-Gnnn-Sn. If. Both warehouse and store data is present it is recorded in that order with a single space character between.

Compétences : Excel, Visual Basic

En voir plus : create tax calculator program, provide description scripts create scripts, type software need create brand clothing, create modify com program, information need create professional band myspace, need create sports betting website, need create flash image banner website, can create activex control button, create online hyip program web site, need create web community, need create content publish, temperture control program using mc68hc11, create standalone excel program, need create auction site, project description need someone to create system for hosting services to state replica of cpanel that can run on windows and ha, project description need someone to create system for hosting services to state: replica of cpanel that can run on windows and h

Concernant l'employeur :
( 0 commentaires ) Boolarra South, Australia

Nº du projet : #30095905

12 freelances font une offre moyenne de 348 $ pour ce travail

asin1987

Dear Employer, I am an Excel expert and have delivered over 1000 projects since over a decade now. I have checked your project details and will ensure highly professional delivery. Kindly check my previous reviews he Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 7 jours
(239 Commentaires)
8.1
khushh07

Hello Greetings to you!! I am an Excel (Macro)/Visual Basic expert and interested to work with your project. I have checked your requirements and that makes complete sense to me. I assure you of a high-quality job. Ple Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 3 jours
(318 Commentaires)
7.3
(230 Commentaires)
6.8
(74 Commentaires)
5.4
Jayant222

I can perfectly help you with that. I am a professional Data Analyst and Excel expert holding years of experience in utilizing advance level tools and functions of Google sheets & Excel (including VBA and Macro) to per Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 3 jours
(19 Commentaires)
3.9
(8 Commentaires)
3.4
Wanngming

==== Able to start work right away ==== Hi, bro! I have read your job specification very carefully. I have rich experiences with Excel VBA and Data Proccessing . As a talented and skillful software developer, I am 100 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 3 jours
(4 Commentaires)
2.4
ArioNugroho

Hello, From what I understand you want to create an automated form that a user will fill in. These inputs will then be compared to the database from Unleashed, that is exported to excel. If there are any mismatch or m Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 7 jours
(1 Évaluation)
0.4
sergidest

Hi, there. I have read your project description very carefully so I had confidence that I can do it. I have experience over 5 years with the skills you required. So this project you post can be completed excellently fo Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 7 jours
(1 Évaluation)
0.4
shaojin

Hello! I have read your requirement carefully, so I am very interested your project. I have rich experience with data processing using Excel VBA in 6 years. I will finish your Excel VBA project in time with high qualit Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 2 jours
(0 Commentaires)
0.0
amareshbeura5

Working with Haque Logistics Privet Limited deputed to (Bharati Airtel LTD) at Bhubaneswar from 01.08.2013 to 14.08.2018. [login to view URL] with Laxmi logistics Private Limited deputed to (Parle agro,Samsonite South Asia pvt.l Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 7 jours
(0 Commentaires)
0.0
architbanthia

I possess very good skills in excel. I know each and every formulas of excel and how to use them. I am better at Formatting the Data and Showing it systematically.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 2 jours
(0 Commentaires)
0.0