Cancelled

Excel Spreadsheet to remove Pick information

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

Skills: Excel

See more: online barcode, barcode online, excel dashboard pick list, excel formula pick correct sheet, vba excel random pick sorted list, excel database guest list form, remove express checkout button zencart, excel project contacts list, excel customer projects list, excel template price list, excel project task list, excel button design

About the Employer:
( 9 reviews ) St Peters, Australia

Project ID: #8550793

12 freelancers are bidding on average $92 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. Wai More

$100 AUD in 3 days
(69 Reviews)
5.8
cgullapalli

A proposal has not yet been provided

$40 AUD in 1 day
(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
(36 Reviews)
4.0
saminatinny

Hi, I did already similar [url removed, login to view] plz plz give me full [url removed, login to view] project is a perfect fit for me because I have extensive experience with data entry. I can also multitask and problem solve with minimal super More

$35 AUD in 3 days
(13 Reviews)
3.7
rahulrahangdale

A proposal has not yet been provided

$200 AUD in 3 days
(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 More

$100 AUD in 2 days
(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
(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 w More

$55 AUD in 3 days
(7 Reviews)
2.7
cijinfrancis

A proposal has not yet been provided

$30 AUD in 3 days
(1 Review)
0.0
paullukic1

A proposal has not yet been provided

$150 AUD in 3 days
(0 Reviews)
0.0
jssuresh

A proposal has not yet been provided

$155 AUD in 3 days
(0 Reviews)
0.0
btripathy76

Dear Sir/Madam, I always perform better than expected of me by virtue of my honesty, sincerity, punctuality and hard work. I am an article writer, blogger, SEO worker, Data researcher, Data entry and soci More

$40 AUD in 2 days
(0 Reviews)
0.0