Completed

Create a script that converts an inventory spreadsheet into packing/shipping labels

This is two separate projects in 1 request. I have two different inventory spreadsheets that I would like to be able to quickly create box labels prior to shipping.

Spreadsheet #1 comes from a manufacturer. It contains a box number and the items in the box. These boxes sometimes contain anywhere from 10 to 100 serialized items. I need to print (on a 4x6 label) the box number (once) and all the serial numbers contained in that box. (these serial numbers can be anywhere from 7 to 22 digits long.

Spreadsheet #2 I create. It contains a box number, the part number, description, and quantity of the items in the box prior to shipping. I need to print (on a 4x6 label) the box number and total number of boxes (i.e. box 7 of 15), the part number, the description, and the quantity. The items going in the box is always dynamic and is rarely the same things in the same box.

I will provide examples of both spreadsheets and both outputs that I'm looking for.

Please let me know if you have any questions.

Skills: Data Entry, Excel, Microsoft Office, Software Architecture, Visual Basic

See more: google docs address label template, how do i make mailing labels from a google spreadsheet, shipping label template, google sheets address book template, how do i print address labels from google spreadsheet, 30 label template for google docs, avery 5195 template google docs, can you print labels from a google sheet, create script install mysql, usps shipping labels expensive, script server inventory database, free restaurant inventory spreadsheet, label city shipping labels, virtuemart shipping labels ups, google checkout shipping labels, source script online inventory, usps shipping labels, create script uninstall office 2003, create script allows users forward address lotus notes, php ups shipping labels

About the Employer:
( 3 reviews ) The Colony, United States

Project ID: #19270553

Awarded to:

nvchien94

Hello there, I am an Excel coder and I can create 2 functions for you in 2 days. 1 day/1task. I can start working right now and promises for the best solution. I created more than 200+ script, include create inv More

$200 USD in 1 day
(79 Reviews)
5.1

18 freelancers are bidding on average $170 for this job

jaylancer43

Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community ( More

$250 USD in 3 days
(706 Reviews)
8.4
schoudhary1553

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. More

$250 USD in 4 days
(344 Reviews)
7.9
P0L

Hello, I’m an Excel VBA expert and I would like to help you with your script. Please check my profile and contact me to discuss further details. Regards.

$150 USD in 3 days
(297 Reviews)
7.2
paris2785

Hi, there! My name is Paris, and I was glad to see that you're looking for an Excel developer. According to your brief, you want to have an Excel application that will create box labels. I plan to use a combination of More

$180 USD in 5 days
(215 Reviews)
7.3
Tanmoy236

"""I am an Excel Expert with Professional experience working with Excel both with Formulas and Macro. Working with complicated formula and Developing Macro programs are part and parcel of my daily work. Completed m More

$150 USD in 3 days
(224 Reviews)
6.9
tranngocanh1702

Hi, I am Khoa with more than 7 years experience in web and cross-platform app development including Hybrid, PHP, Laravel framework, Slim, CodeIgniter, MySQL, PostgreSQL, HTML, CSS, Javascript, jQuery, Vuejs, Ajax, More

$250 USD in 5 days
(104 Reviews)
7.0
lightingdavid

Hello. I have good skills in "Data Entry, Excel, Microsoft Office, Software Architecture, Visual Basic". I have working for 7+ years in this field. I 'm very interest to your project. I have checked your project de More

$140 USD in 1 day
(85 Reviews)
5.9
RushService

Feel fee to contact me for Create a script that converts an inventory spreadsheet into packing/shipping labels .Shoot me message to discuss further more details .We provide the comments,images,videos,demos and live More

$130 USD in 3 days
(47 Reviews)
5.9
mateenbhatti94

Dear sir I have read the requirements and completely understand the project.I will create a script that will do these task to print labels. I have been in this industry for 1 year and such jobs are my daily practic More

$100 USD in 1 day
(71 Reviews)
6.1
sourabhg98

Hey there :), hope you are doing great! This is Sourabh Gupta from New Delhi. I am an advanced Excel VBA programmer, currently at the post of forum expert at www.excelforum.com. I read the description of your More

$88 USD in 2 days
(97 Reviews)
5.4
YuriyStepanovich

Hello, I am talented coder. I have good knowledge to complete your project. I can make your script. Please contact me to discuss more. Thank you.

$333 USD in 2 days
(3 Reviews)
5.0
fastwebsoft

Hello Sir, I have great knowledge in core,cordignetor and Laravel. More than 6+ year experience.. I have read your requirement carefully.. I can do this job easily.. 1. What will be the payment gateway More

$200 USD in 5 days
(8 Reviews)
4.8
Mokshith30

Hi I have Read Your Requirements I am Excel VBA Expert Experianced in VBA Macros & Web Scraping Script... I can finish any kind of vba task in 1 day only pls see my previous projects for my vba experiance T More

$50 USD in 0 days
(37 Reviews)
4.4
GabrielBarreiro1

Dear, I am interested in participating in your project. It is possible to generate labels entirely in Excel. Do you use a template of adhesive labels like Avery? Please share more details with me. I am available, do More

$75 USD in 5 days
(9 Reviews)
3.8
amrosamaeg

Hello, Over 15 years of real experience working as a developer, Top rated freelancer on Upwork Skills, Portfolio, Tests, Education, Certifications, Work/Employment history and feedback can be found in my profile htt More

$222 USD in 7 days
(18 Reviews)
4.5
Xeeshanah

Hi there, i've read your project description and understand your need. I can provide you a windows desktop application with will take those spreadsheets as input and output soft files for labels or possibly directl More

$100 USD in 1 day
(11 Reviews)
3.3
kakkarak1960

Hi, As per reading your description and your requirements, I am offering you that I can provide excel management and information development in accordance with all the requirements which you need. The creation and m More

$200 USD in 3 days
(1 Review)
0.0