Excel Spreadsheet to remove Pick information

$30-250 AUD

Cancelled

Posted

over 8 years ago

$30-250 AUD

Paid on delivery

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

Project ID: 8550793

About the project

12 proposals

Remote project

Active 9 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

12 freelancers are bidding on average $92 AUD for this job

@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 in 3 days

4.9

(69 reviews)

5.8

@cgullapalli

A proposal has not yet been provided

$40 AUD in 1 day

5.0

(62 reviews)

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 in 1 day

5.0

(36 reviews)

4.0

@rahulrahangdale

A proposal has not yet been provided

$200 AUD in 3 days

5.0

(8 reviews)

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 in 2 days

4.9

(8 reviews)

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 in 3 days

5.0

(6 reviews)

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 in 3 days