Find Jobs
Hire Freelancers

Automate an Excel Spreadsheet with Macros

$10-30 USD

Completed
Posted almost 10 years ago

$10-30 USD

Paid on delivery
Create a macro that will automatically populate an excel tab rows with running serial numbers. Info to be entered by our operator : Part Number, starting serial numbers and ending serial numbers. There may be up to 20 part numbers with their own starting and ending serial numbers. Info to be generated automatically : Rows of part numbers, with incrementing serial numbers, depending on the ranges entered by our operator. See attached excel sheet for example of data input format and output requirements.
Project ID: 5868185

About the project

10 proposals
Remote project
Active 10 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
Awarded to:
User Avatar
Hello Valued Client, I have seen your attacment and I believe I can do the work for you in 1 day. I have kept that extra day for communication or other things. In the file I see some columns not marked in yellow, but shows up in the result (like pallet). I see it is by default 1. I'll include this, as well as the 'Count' column (marked in light grey) if you need it. I can automate that the output sheet is named accordingly too. For example for PO of 41103, the resulting sheet shall be named "41103 Output" automatically. I think instead of a button you can make it a normal macro as well. so wheneverthere is data in the first sheet that has a structure like this, it shall create output sheets accordingly. I can make it an excel addin as well, so that the button is in the menu bar (instead of the sheet). All in the same price. So, do message me if you want further discussions. I have done several jobs like this, and this is very easy for me. Thanks & Regards Raad
$25 USD in 2 days
5.0 (33 reviews)
5.1
5.1
10 freelancers are bidding on average $26 USD for this job
User Avatar
Hey There, Thanks for posting the project. Its looks feasible and am Interested to do it. Next steps: Lets discuss/validate the complete requirement and I can start to get this done with required quality output. I am an excel/access VBA automation professional having 7+ years of experience and can do it with the required quality. Lets discuss more online on chat. Thanks, Abhinav
$49 USD in 2 days
4.9 (142 reviews)
6.4
6.4
User Avatar
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. Regards
$25 USD in 1 day
4.9 (62 reviews)
5.7
5.7
User Avatar
I am An Excel - vba Expert and I can help U pm me ...............................................................................
$35 USD in 1 day
5.0 (38 reviews)
5.3
5.3
User Avatar
A proposal has not yet been provided
$30 USD in 1 day
4.8 (18 reviews)
4.2
4.2
User Avatar
Dear Sir, I'm quite interested by your project. I am programmer with sincere and capable. I have developed many project. Particular, I have rich experience in VBA project. I can provide you the best cheap prices the best results. If you had interest for my suggestion, please call me. I await for you. Best Regards.
$14 USD in 1 day
5.0 (3 reviews)
2.4
2.4
User Avatar
Hi Yung Ming Lee, I saw you Excel file along with your macro, and understand your requirement of creating an automated serial numbers, based on the user inputs. I can clearly do the project for you, and moreover I will give an useful view of the sheet, which can be useful for any other analysis. To be honest, I am good in Microsoft Office Package, along with the VBA. You can see my Excel Add-on, that I have created, in my portfolio. I can finish this project in less than a day, hope so, if your objectives does not differ. Thanks for the opportunity. You can contact me at any time.
$14 USD in 1 day
5.0 (3 reviews)
1.9
1.9
User Avatar
I am a quick learner and hard worker with a sense of team work,I have strict professional and ethnic high sense of confidentiality.i hold excellent communication,organizational and managerial skills and I adapt easily to change social and business environment,kindly i need this job.
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of SINGAPORE
Singapore, Singapore
5.0
8
Payment method verified
Member since Apr 17, 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.