Find Jobs
Hire Freelancers

MS Excel Automation & Macros

$30-250 USD

In Progress
Posted over 7 years ago

$30-250 USD

Paid on delivery
SEE ATTACHED FILE. ALL THE 9 RED FIELDS ON THE "AVERY 5163 SHIP LABEL TEMPLATE" TAB SHOULD BE AUTOMATICALLY PICKED UP FROM "PACKING LIST WITH CARTON INFO" TAB. PO BOX#: ON"AVERY 5163 SHIP LABEL TEMPLATE" TAB - SHOULD MATCH THE PACKING LIST FOR PRODUCT DESCRIPTION AND BOX NUMBER AND THE NUMBERS MUST RUN SEQUENTIALLY ON EVERY LABEL. SO, ON THE NEXT LABEL IT WILL BE BOX 2 AND SO ON. FOR THIS EXAMPLE, THE LABEL TEMPLATE TAB SHOULD AUTO GENERATE 20 LABELS BASED ON DATA FROM THE PACKING LIST TAB. 1 SHEET HOLDS 10 LABELS, SO IN THIS EXAMPLE, WE WILL HAVE 2 SHEETS TO PRINT. LABEL SHEETS CANNOT BE ON SEPARATE TABS, THEY MUST BE CONTINUOUS ON THE SAME SHEET/TAB. THE FOLLOWING TAB 3 - FINAL OUTPUT SHOWS THE FINAL RESULTS WE ARE LOOKING FOR AFTER AUTOMATION BASED ON THE DETAILS OF THE PACKING LIST. PREFERENCE WILL BE FOR THE FINAL OUTPUT FOR LABELS TAB BE AUTOMATED AS THE PACKING LIST IS BEING MADE WITHOUT ANY USER INTERVENTION.
Project ID: 11561289

About the project

11 proposals
Remote project
Active 8 yrs ago

Looking to make some money?

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
11 freelancers are bidding on average $95 USD for this job
User Avatar
ZERO ERROR GUARANTEED!! Please read my 130+ reviews. Hi, I can do this for you quickly and with great quality for cheap...Based in Nepal we provide quality work, and 100% satisfaction guarantee..We are not satisfied with the work until you are. Please read some of my customer reviews then contact me immediately. Thanks.
$100 USD in 3 days
5.0 (217 reviews)
7.2
7.2
User Avatar
Dear Project Poster, I have relevant hands on 5 years of experience .We have a team of all the skills. I assure you about the work quality and time delivery. Please give me chance to complete this project. I Have 100% completion ratio. I had already done the same work in past. Looking forward to hear from you. Let me give an opportunity to work. We can talk further when you message me.
$94 USD in 2 days
4.9 (214 reviews)
7.3
7.3
User Avatar
Hello. 35 % of employers hiring me once hired me again. I have experience in the same. I CAN do this job, and do it well!
$90 USD in 3 days
4.9 (106 reviews)
6.3
6.3
User Avatar
Hi, Thank you for the invitation. I have already found your project and went through the requirements. It's pretty straight-forward. It can be done to be very user-friendly. When Packing list tab is filled the user will have to press a single button and Final Output will be filled in a few seconds. I can finish it by the end of the day. Regards, Balint
$120 USD in 1 day
5.0 (82 reviews)
6.2
6.2
User Avatar
Hello, Thank you for your invitation! My name is Chris and, as you can see from my profile, I have 16 years experience with Excel/VBA and 13 years teaching them both. I read carefully your post and reviewed the attached file. It's clear how to fill-in the labels sheet. I have only 2 questions. The first one has to do with the way this automation will start. There are 2 possible ways: 1. The user adds all data into "Packing List" and then presses a button (shown this tab) to fill-in the corresponding labels. 2. Labels are created as the user is entering data into the "Packing List". The first method requires user's intervention, while second method not. However, second method maybe slower than the first one, especially in case the user makes changes or fixes to the entered data, because the code has to check for any change on this range and adjust te labels accordingly. Second question: Do you want also a button (and code) for printing the labels? Looking forward to hear from you, Kind regards, Chris (chriskerpini)
$90 USD in 2 days
4.9 (63 reviews)
6.4
6.4
User Avatar
Hi, I have more than 14 years of VBA/Excel and macro exp and I am expert in this kind of work. I have completed more than 280 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.
$100 USD in 3 days
4.9 (115 reviews)
6.2
6.2
User Avatar
I can do it for you quickly and exactly .
$90 USD in 2 days
4.9 (89 reviews)
6.3
6.3
User Avatar
Hi, I have a university degree in economics and IT, and several decades of system design and programming, in the recent decade especially in Excel and VBA. In my approach you'll have opportunity to consult details with me, to test pilot solutions if necessary in order to achieve an optimal final solution. Further use of macros, fixing of bugs and minor changes are included in the bid without any additional fees. I have great experience in any kind of data manipulation with Excel/VBA. I can start working on the project immediately and complete the job within one (max two) days. Regards
$77 USD in 2 days
4.9 (62 reviews)
5.7
5.7
User Avatar
Hello, I am proficient with Excel and VBA and I would love to help you with this project. I have a lot of experience with similar work. Please contact me for more information.
$96 USD in 3 days
4.9 (119 reviews)
5.7
5.7
User Avatar
I am an expert in Excel and all excel functions and excel automation, macros, vlookup concepts, Have done many mail merges for automatic templates based on the data set. Can work on your requirement
$88 USD in 3 days
4.9 (46 reviews)
5.2
5.2

About the client

Flag of CANADA
DELTA, Canada
5.0
15
Payment method verified
Member since Jan 12, 2014

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.