Find Jobs
Hire Freelancers

Build A Script to Create Individual Lists From a Master List

$50 USD / hour

Completed
Posted about 7 years ago

$50 USD / hour

Need a VBA script to do the following in Excel: - Create [number] lists containing [number] rows of data. - No more than [number] Company names per list. - Company must not repeat within the last [number] of lists. See attachment for example.
Project ID: 13337808

About the project

39 proposals
Remote project
Active 7 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
Hi, I am good at Excel and building useful scripts for my clients. I just checked the description you have provided regarding the project and would be a pleasure to assist you on your project. I will work with full dedication to give you the best output within the desired timeframe. I look forward to hear from you. Looking forward to discuss in the chat and a long term relationship ahead. Wishing you a great day ahead. https://www.freelancer.com/u/cgullapalli.html#/profile-reviews Regards, Chandra
$50 USD in 3 days
5.0 (1219 reviews)
8.4
8.4
39 freelancers are bidding on average $52 USD/hour for this job
User Avatar
Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of experience of 5 years. b) I work very hard (16+ hours a day and 7 days a week) and also very fast so... it will be done very soon than most of the other providers c) And most important part is my policy: "I will give you (to my client) life time support (as long as you keep relation with me). And fix any bugs/problem without any cost. So, don't ever worry about me” Please sir, leave a reply ASAP, as I am waiting for your kind reply
$50 USD in 1 day
4.9 (541 reviews)
8.4
8.4
User Avatar
Hi A message box will ask you how many companies to include in each list. In which format do you want to save the files? In the same folder or you need to specify one?
$50 USD in 4 days
5.0 (406 reviews)
7.9
7.9
User Avatar
Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
$50 USD in 2 days
5.0 (498 reviews)
8.0
8.0
User Avatar
Greetings! If Input and output are as shown in figure, then it is pretty straightforward and I can write a macro for $20. Regarding the requirements, are you looking at creating multiple lists from a single master list with criteria specified in requirement 2? - Create [number] lists containing [number] rows of data. Company must not repeat within the last [number] of lists. If so, my quote is $45. I have 17+ years experience in using Excel as part of my daily work life. In the process I have implemented lot of automation / modelling as well as dashboards for Management Reporting. In fact, over the last few MONTHS , I have spent at least 225 HOURS on automation in Excel every month. Looking forward to hearing a positive response from you. Have a Great Day! Srinivasan Krishnamoorthi
$55 USD in 10 days
5.0 (258 reviews)
7.2
7.2
User Avatar
I have experience in MS Office, VBA Programming, XML, MS Work, Google Docs, SQL, Google Spreadsheet, Data Entry in Odoo, Google Document and other related applications. I believe my capabilities would be perfect for your project. I can complete this job within the necessary period. I have years of encounter in this work and can offer you my past taste work. I will be offering you with all my effort and capabilities. “Moving ahead, I can dedicate 35 hours/week for your job, and my daily hours are negotiable. I’m very empowered to offer my services for your job. Please you can get in touch with me instantly to discuss this place further.” I am mostly online at Yahoo Messenger, Google Talk and Skype. We can discuss there in details, if you are interested. I wish you'd give me this chance. Regards, Mohsan Ijaz
$50 USD in 40 days
5.0 (100 reviews)
6.9
6.9
User Avatar
Hi, I have more than 14 years of Excel/VBA exp. I have completed more than 300 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.
$50 USD in 2 days
4.9 (122 reviews)
6.3
6.3
User Avatar
Hi, Experienced Data Analyst and Macro Developer. I have read your instructions carefully. I have seen your attached jpg and understood your requirements. I will extract only specified number of records from master list and create new list. I have excellent knowledge and experience of Manipulating Data of Sheets, Applying Advanced Formulas and Creating Reports. I have done mostly this type of job where data manipulation is required. Please check my portfolio to see my work – https://www.freelancer.com/u/vsprybhanu.html?page=portfolio Ready to start please reply soon. Thanks, Virendra
$50 USD in 2 days
4.8 (136 reviews)
6.2
6.2
User Avatar
I am experienced at retrieving data from various external sources and also creating custom lists from data in worksheets from one or multiple workbooks.
$55 USD in 40 days
5.0 (9 reviews)
5.6
5.6
User Avatar
Hello. I have read your project description but I need to ask few questions. I wouldn't call myself a master but I do work smart and my first priority is to satisfy my clients. Please feel free to ping me anytime so we can have a detailed discussion.
$55 USD in 40 days
5.0 (5 reviews)
5.4
5.4
User Avatar
Sir, I am well versed in this kind of jobs and can do your project as per requirement. I have over 8 years of experiences and will give reference of my online work portfolio once I heard from you. I have all the resources ready to do your project as per your requirement I am very much able to work on this. ***I am ready to start Waiting to hear from you. with thanks and regards
$55 USD in 40 days
4.6 (45 reviews)
5.6
5.6
User Avatar
Hello, my name is Ryszard Jędraszyk and I'm a full-time VBA developer. I have taken a look into attached file and understand the requirements. I'll use cells to store variable numbers which macro will use to produce the output list or lists. The project is well explained and for now I don't have any questions, maybe apart from the details of output layout, for example should the lists be in one column separated with a blank row or maybe in subsequent columns (possibly separated with blank column). I will have it done within 48 hours since awarding the project. Regards
$50 USD in 1 day
5.0 (62 reviews)
5.3
5.3
User Avatar
I have a script to create that. I want to send you a concept if you would like to. I'm sure it will not more than 4 hours. I hope you'll reply over chat then we'll discuss further. Thanks
$50 USD in 10 days
5.0 (46 reviews)
4.7
4.7
User Avatar
Hey there, From the sounds of it, you need an Excel expert who can write optimized formulas, VBA code and analyze data. Is that sounds about right? I have an extensive knowledge of Excel included VBA. I have also a strong database and analytic background that could be a profit in your project. I've successfuly completed many Excel projects for random clients. Always on time and budget. What is your favorite way to comunicate? Best regards, Rafael Ps. This could be one of my first projects here, so give me the chance to proof that i'm really good business partner. I'm sure that i wont let you down.
$50 USD in 40 days
4.9 (17 reviews)
4.5
4.5
User Avatar
Hi there, Hope you're doing well. I'm an Excel expert with rich VBA programming. I'm interested in the job and can get it well done with good quality on schedule. Feel free to contact me and discuss more details. Best Regards, VL
$50 USD in 20 days
4.9 (11 reviews)
3.9
3.9
User Avatar
Hi, my name is Mike, I’m based in Oxford, UK. I work with individual clients and agencies who have design, development and SEO needs. Your project description sounds interesting to me and I do have skills & experience that are required to complete this project. I can show you some examples of my work. Please contact me to discuss your project.
$55 USD in 40 days
5.0 (1 review)
3.6
3.6
User Avatar
Experience in vba for four years
$57 USD in 30 days
4.1 (7 reviews)
4.4
4.4
User Avatar
I have 4+ years experience in data analytics, working on small excel reporting to big DWBI reporting work. I am an expert in developing user-friendly spreadsheets for data analysis and visualization, creating interactive KPI dashboards using pivot tables, slicers, and graphs. Projects range from long-term support of data analysis and visualization needs to short-term specific projects. Skills: - Excel/VBA Automation - Excel Dashboards & Reporting (Data Visualization) - QlikView/QlikSense/Tableau (Data Warehousing and Business Intelligence) - Microsoft Access (SQL) - SAS / R Language - Data Analytics (Executive Decks/Analysis - Key Results and Insights) - Commercial Insights and Analytics Once I receive a project, my biggest priority/focus is to ensure that quality work is delivered always on time. Give me an opportunity, I will deliver you the quality. Warm Regards, Rohit Ahuja | Mobile: +91-8527610117 |
$50 USD in 40 days
5.0 (7 reviews)
3.4
3.4
User Avatar
Hi, I am Prasad,interested to take up the your work. I will charge only $50 for completing the task.(But actually may take,say, one day to finish it and send the document) I will not take any advanced mile stones. I will do the work and send you with some restrictions,(ex: like a trial version which can be used only for a limited period).If you are happy with it make the payment and I will send the final product. If you are interested please share the details. Thanks and regards, Prasad.M
$50 USD in 40 days
4.7 (2 reviews)
0.9
0.9
User Avatar
Am ready and passionate to work. I have a teachable spirit ready to move hand in hand with my employer to providing quality work.
$55 USD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I can make a macro-enabled excel workbook for you that will analyze a given range of a certain spread sheet and tells you if it is logically possible to meet the desired conditions (1 to 3) then it will add the generated lists as separate sheets to the same workbook if possible. I had to post my bid as per hour but I'll do it for the amount shown in "total" within up to 24 hrs delay max. Please feel free to write to discuss any further details: structuralengineering2017 @G-Mail
$50 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
New York, United States
4.9
56
Payment method verified
Member since Nov 21, 2015

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.