Find Jobs
Hire Freelancers

Excel macro: splitting up lines - open to bidding

$8-15 USD / hour

Completed
Posted over 10 years ago

$8-15 USD / hour

I am looking for a short Excel macro. What I want it to do is splitting up lines in a table based on cells with have values separated by Alt+Enter. It should be possible to use a table of variable size (e.g. by defining table size), and the splitting up should take place for a column that I can choose freely (e.g. column B or column F or ... to be defined in the macro). The cells other than in the split-up column should remain unchanged. I added a sample excel file...
Project ID: 5311731

About the project

28 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
Hi, The macro is ready. you will be having the below options. 1. press Cntrl + o to enter the column to split and table column range 2. press split button. I am not very sure how to post the screen cap here. let me know how can I pass you the mock-up file? Note: I spent 2hrs on this. however you can pay for 1hr or can use it for free :). Thanks & Regards PC
$8 USD in 1 day
4.9 (5 reviews)
1.4
1.4
28 freelancers are bidding on average $14 USD/hour for this job
User Avatar
hello respected sir , i m interested , i can do ur project its simple for me, i m expert in excel,,,u hv to just give sample file to understand it, i waiting for ur positive reply thanks
$8 USD in 1 day
4.9 (227 reviews)
7.4
7.4
User Avatar
Hi CS. I have read the description and I can do the splitting up job in 2 hours for you. Lets begin and get the task done. I can get the job done for you for 50 USD. Regards. Usman.
$25 USD in 1 day
5.0 (85 reviews)
6.9
6.9
User Avatar
VB, VBA and Databases expert for over a decade. Master in Information Systems. I can start right away. For any questions, please let me know. I am going to need 3-4 hours for $50 Paris
$50 USD in 1 day
4.9 (121 reviews)
6.5
6.5
User Avatar
Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 200 projects. Please look at the feedback left by my employer to know more about my work. Waiting for your positive response. Thanks.
$11 USD in 1 day
4.8 (120 reviews)
6.3
6.3
User Avatar
Hi, I have worked as pricing analyst for 4+ years. During this stint, I have worked on projects involving elasticity analysis, break-even analysis, regression and price models. In my projects, I work extensively on excel. I have successfully completed similar projects for 'Sadebow'. You may have a look at review provided. Please revert back for any questions/clarifications. Regards! Vikas
$15 USD in 3 days
4.9 (38 reviews)
5.7
5.7
User Avatar
Hi, I went through additional details provided by you. It would take around 6 hours time spread over the entire week. Also inside the macro I will mark with comments line of code which can be changed to indicate the table size and also the column name by which split needs to happen. I am assuming that split at any point will happen only by one column. The rest of the columns will remain unchanged. In case you faster turnaround , I mean less than a week then please do let me know. Looking forward to working with you. Thanks ========== Hi, Please share the attachment that you mentioned in job details. Let me introduce myself as an expert VBA programmer. I have used VBA extensively for Excel, MS Word etc.. I have more than 10 years of experience to my credit. I have also worked on advanced VB features like making of ActiveX Exe, ActiveX dlls, OCX, Win32 API, multi-threading etc.. I fully understand on this highly competitive site how important it is to provide high quality work. My prime focus is 100% customer satisfaction. I would be happy to answer any queries that you may have. Looking forward to working with you. Thanks & Regards FineCoder
$14 USD in 6 days
4.9 (66 reviews)
5.5
5.5
User Avatar
A proposal has not yet been provided
$16 USD in 1 day
5.0 (123 reviews)
5.3
5.3
User Avatar
Hi, Ready to work on your project. Please send the file to view it. Please also check my reviews for work confidence. Thanks Dhirendra
$13 USD in 6 days
5.0 (52 reviews)
5.4
5.4
User Avatar
Hi I have been developing applications in Excel for 20 years plus with extensive use of VBA. I have developed several applications for Freelance clients, please see Feedback. I am UK based, a native English speaker, available on Skype and currently on UTC. I am particularly keen to work with an employer who uses freelancers regularly, as you clearly do. I have studied your sample and it is quite do-able. I expect that a range selection on screen prior to firing the code would work fine. I am available now and would aim to complete in 2 days based on 1hr per day with a revue from you in between. Please make contact and I can mock up a sample. Regards David
$10 USD in 1 day
4.9 (33 reviews)
5.1
5.1
User Avatar
Expert at Excel 2003-2010 and Excel VBA Macros. Please allow me to do it. Will ensure everything is as per your requirement.
$12 USD in 1 day
4.9 (33 reviews)
4.3
4.3
User Avatar
I would be delighted to do this for you, but there are two challenges. (1) You didn't attach the sample referred to in the description, and (2) What do you mean by "split up lines"? Do you want the Code to insert blank rows below the row containing split cell(s) to match the number of values found? I designed dashboards, reports and spreadsheets and managed databases for twenty years at a leading multinational. Now work from home in the UK across five freelance sites, with good reviews from international clients who have utilised my expertise in VBA Coding, Formulae and Conditional Formatting. I normally provide samples to let you judge my Excel skill for yourself, but as you made this a "restricted" project I can't send an attachment unless you send me a Private Message first. Happy to work under a Confidentiality and Non-Disclosure Agreement if required, and will start as soon as you pay the Milestone into the site and send me your existing material. Hope you find this of interest and look forward to hearing from you Bob Allen-Turl
$33 USD in 1 day
4.5 (12 reviews)
4.4
4.4
User Avatar
I’m a very advanced level Excel user for more than 12 years. I’ve developed a number of formats & templates for many organizations including UN, Concern Worldwide, NETZ Germany, CGE Australia, CoreRx Pharma etc based on formulas, options & VB macro. If needed I can forward some of my previous works to you which I’m sure will satisfy you about my expertise. As an expert in office automation I’ve successfully supervised & completed two international office automation projects. I saw your requirement. This type of work is my day to day work & I’ve done some similar projects in the past. So I’m quite confident doing your project if you kindly allow me to do so.
$8 USD in 5 days
4.7 (4 reviews)
3.8
3.8
User Avatar
Thanks for your clear instructions. I will provide you VBA macro script under windows excel which will allow you to select the range to be processed. The script will be easy to use. Thanks
$8 USD in 2 days
4.9 (17 reviews)
3.7
3.7
User Avatar
Hi! I went through your description and I believe I will be able to complete and deliver the project as required. I have worked on many Macro projects and also completed two of them here at freelancer.com. Looking forward to hear from you. Thanks.
$8 USD in 1 day
5.0 (3 reviews)
2.2
2.2
User Avatar
Dear Freelancer, I know to do a macro in excel, and I hope that you will be content. Regards, ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
$12 USD in 1 day
5.0 (2 reviews)
1.2
1.2
User Avatar
I'm an expert programmer in VBA Excel, i can do it this project and make you the user manual for next time you want do it by yourself
$12 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I have lot of experience in data processing ( merging/ duplicate removal) using Excel VBA macro. I can do this for you within couple of hours. BTW you asks to select you need to select columns, how do you want this done( can you edit the macro your self or do you need pop up box sort of input option)
$10 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Er is nog geen voorstel voorzien
$15 USD in 6 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A strategic and logical thinker with excellent knowledge in identifying and defining marketing opportunities and problem having rich experience of 11 years in Market Research Analysis & Project Management • Experience in analysis principles and tactical evaluation of the market environment. • Skilled in generating, refining, and evaluating marketing actions. • Proficient in designing the method for collecting information, managing and implementing the data collection process. • Expertise to set strategic priorities on all aspects of market. • Proficient analyzing the results and communicating the findings and their implications
$12 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Ainda não foi fornecida uma proposta
$11 USD in 20 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of GERMANY
Leipzig, Germany
5.0
67
Payment method verified
Member since Nov 17, 2011

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.