Find Jobs
Hire Freelancers

VBA Script: Count Columns and create new row

€30-250 EUR

Closed
Posted over 6 years ago

€30-250 EUR

Paid on delivery
Hi, I have a file with 200 rows. I need a script which does the following: - Go through each row - Delete all empty columns of a row - Count all content of a row and if there are more than 30 columns then - create a new row with the rest of the columns (if again above 30 columns then create a new row again)
Project ID: 15269617

About the project

105 proposals
Remote project
Active 6 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
105 freelancers are bidding on average €80 EUR for this job
User Avatar
Hello Sir, Thank you for this opportunity. My name is Jay and I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among niche bidders who have 0 failed projects and 100% completion rate since I do not bid on projects which I am not certain of. I will not disappoint you, please give me an opportunity to work with you. No milestones required. Pay me only when your job is 100% done. Also I will provide you with a sample work before you consider awarding me the project. Thanks, Jay
€150 EUR in 2 days
5.0 (863 reviews)
9.2
9.2
User Avatar
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). Please sir, leave a reply ASAP, as I am waiting for your kind reply
€180 EUR in 3 days
4.9 (521 reviews)
8.4
8.4
User Avatar
Hello, I’m an Excel/VBA expert and I would like to help you with this script. Please check my profile and contact me to discuss.
€50 EUR in 1 day
5.0 (494 reviews)
8.0
8.0
User Avatar
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. Best regards
€50 EUR in 1 day
5.0 (330 reviews)
7.4
7.4
User Avatar
Greetings! Thanks for being very clear about your requirement - requirement is straightforward and easy to implement. I can write a macro that meets your requirement. I have 18 years experience in using Excel as part of my daily work life. In the process I have implemented lot of automation similar to what you are expecting as well as dashboards for Management Reporting. In fact, over the last 15 MONTHS , I have spent at least 250 HOURS on automation in Excel every month. Have a Great Day! Srinivasan Krishnamoorthi
€30 EUR in 1 day
5.0 (259 reviews)
7.1
7.1
User Avatar
Hello Sir, I am a VBA expert and I can help you with this project. Please open chat to discuss more about this project and my approach. Also can you please share which excel version are you using? Thanks Aanvik
€222 EUR in 3 days
5.0 (56 reviews)
6.8
6.8
User Avatar
Hello, dear sir! I registered at the forum not so long ago, but I already have several completed projects on www.freelancer.com. I am ready to carry out your project in the minimum price and in the shortest possible time and with the highest quality! From the Excel, of course, familiar. Give me a chance to show what I can do!
€39 EUR in 1 day
4.9 (188 reviews)
6.9
6.9
User Avatar
Hi: I can create a macro (VBA) script which would go through the rows and create more rows in case there are more than 30 columns. I am Excel expert. Please review my profile (https://www.freelancer.com/u/aarifakhtar) for details about my expertise and previous work. I have ~100% project completion and 5-star feedback on >150 projects. I take payment only after work completion.
€50 EUR in 2 days
4.9 (173 reviews)
7.1
7.1
User Avatar
Hello. I can provide a VBA script which will count columns and create new row. I have 5 years experience in Excel VBA.
€93 EUR in 2 days
5.0 (122 reviews)
6.6
6.6
User Avatar
Hello! My name is Irnes and I'm a data entry/web search specialist from Bosnia and Herzegovina. I'm here to prove my skills and quality of the work. The Freelancer website gave me a preferred status. More than 95% of my completed projects are done on time, 100% on budget. My bid is negotiable only when the amount of data is not precise. I have never changed my bid or asked the client for more money when the project is accepted. My best skills are: - any type of data entry, data collection - MS Office related jobs - PDF conversion to any format - web search / internet research / web scraping - posting the listings on the websites. - video and photo editing jobs. On the bigger projects, I work with the cooperates. My reviews on the Freelancer website are speaking enough about my ability to work. I'm not placing the bid if I'm not at least 80 % sure that I can do the job. I accept the project only when I'm 100% sure that I can complete it on budget and on time. Hope you'll recognize my interesting and contact me. Thank you for reading this. :) Best regards, Irnes.
€50 EUR in 1 day
5.0 (78 reviews)
6.8
6.8
User Avatar
Hello. I have enough experience with Excel and VBA in order to complete this task in short time. Meantime I have few questions: 1) Should it shift data left when removing particular empty cell in middle of the row? 2) If last data row contain less than 30 columns, should not it continue? Thanks,
€30 EUR in 1 day
4.9 (451 reviews)
6.7
6.7
User Avatar
I have experience in Excel, VB, VB.net, 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
€61 EUR in 3 days
5.0 (101 reviews)
6.7
6.7
User Avatar
Hey There, Thanks for posting the project. Its looks feasible and am Interested to do it. I am an excel/word/outlook VBA automation professional having 7+ years of experience and can do it with the required quality. Next steps: Lets discuss/validate the complete requirement, budget and I can start to get this done with required quality output. Lets discuss more online on chat. Thanks, Aman
€50 EUR in 1 day
4.9 (177 reviews)
6.5
6.5
User Avatar
A proposal has not yet been provided
€111 EUR in 1 day
4.8 (88 reviews)
6.4
6.4
User Avatar
Hi, I am interested in your project. Please provide the file you need the script created for. Thanks, Peter
€155 EUR in 3 days
5.0 (51 reviews)
6.0
6.0
User Avatar
Hi, I have gone through your project details and can help out in getting vba script done as per your need which will function as per given instructions. I have worked on several vba/macro projects on excel and can handle yours efficiently and complete it quickly. Waiting for your response further. Thanks.
€50 EUR in 0 day
4.8 (112 reviews)
5.9
5.9
User Avatar
Hello, I am ready to start the work anytime. Price for the project is €30, fast delivery, complete in 2 days. Regards, Santos
€30 EUR in 2 days
5.0 (122 reviews)
6.0
6.0
User Avatar
Hi I hope all's well with you. I see you're looking for a developer proficient in Ms Excel/VB. Really all my projects here I've developed for Ms Access/Excel/VB projects. Would you like to have it via Ms Access GUI with Excel automation or via VB.NET with Ms Access DB as backend?I'll code that within Excel using sql/ado/vba. ...here you can read my introduction: I’m a ms Access/VBA programmer, a mathematician and a full time developer with a strong background developing a wide range of accounting, economical, statistical and mixed type projects using Ms Access, Ms Excel, Ms Word, VBA, ADO, SQL including projects for start-up companies and small businesses. For over the last 25 years I’ve worked in a variety of industries. I have a deep passion for coding and guarantee that all of developing is 100% original. I highly value professionalism and hold myself strictly accountable to represent my client’s brand. I aim to form a long-term working relationship. Please, let me know what is needed to secure this bid! Thank you for your consideration. Zu
€83 EUR in 2 days
4.8 (48 reviews)
6.2
6.2
User Avatar
Hello, i'm an experienced VBA developer and full time freelancer. I can handle this project. I will be able to get this tool done to you in a few hours once the project is accepted. Awaiting for your most precious reply. Thank you, Karthik.
€50 EUR in 5 days
4.9 (114 reviews)
5.8
5.8
User Avatar
Hi, i can help you with this project, please let me know more about it :) .
€30 EUR in 1 day
5.0 (31 reviews)
5.4
5.4

About the client

Flag of GERMANY
Halstenbek, Germany
5.0
39
Payment method verified
Member since Sep 30, 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.