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
Current Pick Zone - CH4 BG3CD3
Pick = CH4
Bulk = BG3CD3
New Location "AD2"
Function "Add Bulk"
Here is an Example 2
Current Pick Zone - AK4 BI3DG2
Pick = AK4
Bulk = BI3DG2
New Location "AL2"
Function "Replace Pick"
Here is an Example 3
Current Pick Zone - DM4 CE2DM2DK3CJ3
Pick = DM4
Bulk = CE2DM2DK3CJ3
New Location "CJ3"
Function "Remove Bulk"
12 freelancers are bidding on average $92 for this job
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