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