Excel Spreadsheet to remove Pick information

$30-250 AUD

Anulowano

Opublikowano

ponad 8 lat temu

$30-250 AUD

Płatne przy odbiorze

The excel sheet should do the following process 1. Download this file each time it is opened 2. Have a box to enter a Barcode or SKU (we will attach a barcode scanner to the PC) 3. Look up the "Pick Zone" information for this SKU 4. The first 3 characters are "Pick" , characters 5-24 are "Bulk", show in 2 boxes 5. Have a box to enter new Location 6. Have a button for "Replace pick" , "Add to Bulk", Remove from Bulk" 7. Create a list of changed "Pickzone" and "SKU" to export as CSV (preferably online if possible - eg export the CSV file to a URL address Here is an Example 1 SKU 10012 Current Pick Zone - CH4 BG3CD3 Split Pick = CH4 Bulk = BG3CD3 New Location "AD2" Function "Add Bulk" Result SKU,Pick Zone 10012,CH4 BG3CD3AD2 Here is an Example 2 SKU 10018 Current Pick Zone - AK4 BI3DG2 Split Pick = AK4 Bulk = BI3DG2 New Location "AL2" Function "Replace Pick" Result SKU,Pick Zone 10018,AL2 BI3DG2 Here is an Example 3 SKU 10031 Current Pick Zone - DM4 CE2DM2DK3CJ3 Split Pick = DM4 Bulk = CE2DM2DK3CJ3 New Location "CJ3" Function "Remove Bulk" Result SKU,Pick Zone 10031,DM4 CE2DM2DK3

Excel

Identyfikator projektu: 8550793

Informację o projekcie

12 ofert

Zdalny projekt

Aktywny 9 lat temu

Szukasz sposobu na zarobienie pieniędzy?

Adres e-mail

Korzyści ze składania ofert na Freelancer.com

Ustal budżet i ramy czasowe

Otrzymuj wynagrodzenie za swoją pracę

Przedstaw swoją propozycję

Rejestracja i składanie ofert jest bezpłatne

12 freelancerzy składają oferty o średniej wysokości $92 AUD dla tej pracy

@dpune

Hi, I have more than 14 years of VBA/Excel exp and I am expert in this kind of work. I have completed more than 250 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.

$100 AUD w 3 dni

4,9

(69 opinii)

5,8

@cgullapalli

A proposal has not yet been provided

$40 AUD w 1 dzień

5,0

(62 opinii)

4,9

@redouaneaberdin

Hi there My name is Redouane I am very interested in your project. Kindly start messaging so we can discuss further details. Thank you

$100 AUD w 1 dzień

5,0

(36 opinii)

4,0

@rahulrahangdale

A proposal has not yet been provided

$200 AUD w 3 dni

5,0

(8 opinii)

3,2

@webexpertkunal

Hi First of all thanks for your job post. It is pleasure for me to place a proposal on your job post. We’re very much confident to complete the job as per your need. After reviewing your project description we got the clear picture about your job. We're eagerly waiting for your response. We will be happy , if we can make a successful business deal and discuss more about the project. So that we can give you a favorable result with our excellence work. Thanks and Regards WEBEXPERTKUNAL

$100 AUD w 2 dni

4,9

(8 opinii)

3,1

@slenders13

Dear client, I have a lot of experience with VBA and Excel. Send me a message for more information. Looking forward to work with u. Kind regards, Rens Slenders SlenDATA

$100 AUD w 3 dni

5,0

(6 opinii)

3,2

@sunil440

Good day! I would like to submit my application as Data Entry Expert. I shall be pleased to consider me as a qualified applicant.I believe my qualifications would make me an outstanding asset to your organization. I would appreciate the opportunity to meet with you. I look forward to hearing from you

$55 AUD w 3 dni