Find Jobs
Hire Freelancers

Sort data in a spreadsheet using macros and conditionals

$10-30 USD

Closed
Posted almost 7 years ago

$10-30 USD

Paid on delivery
I have a large list that I need sorted. Basically it will need macros and some conditional formatting. I have provided a sample of the spreadsheet I'm working with. If the person has a phone number all their info must be duplicated into a new row and the phone number copied into that new row. Each row can only have one phone number to match with the person. Same with emails - Emails will need a duplicate row for each email provided. The end result will look like 6-10 rows where the columns are identical until you reach the phone number and email field. The first few rows are how the end result should look.
Project ID: 14911299

About the project

49 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
49 freelancers are bidding on average $23 USD for this job
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. Stay tuned, I'm still working on this proposal.
$30 USD in 1 day
4.9 (405 reviews)
7.6
7.6
User Avatar
I can write a macro that can be used to generate one unique row entry for each of the Phone nos. (and similarly for each of the email IDs). I have written many such algorithms in past projects. Relevant Skills and Experience 18 years experience in using Excel as part of daily work life. In the process, implemented lot of automation. Over the last 12 MONTHS , spent at least 225 HOURS on automation in Excel every month. Proposed Milestones $25 USD - Macro to add rows for Phone / EMail
$25 USD in 1 day
5.0 (211 reviews)
6.9
6.9
User Avatar
Dear client, I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me. Roy Relevant Skills and Experience excel, vba, macro Proposed Milestones $30 USD - after completion
$30 USD in 1 day
4.9 (425 reviews)
7.1
7.1
User Avatar
I am ready to carry out your project in the shortest possible time and with the highest quality! Relevant Skills and Experience Excel, vba Proposed Milestones $30 USD - Project completed
$30 USD in 1 day
5.0 (80 reviews)
6.2
6.2
User Avatar
Greetings for the day!! We have experience working on this subject. We ensure 100% QUALITY with ON-TIME Deliveries. Please allow us to take this opportunity. Thanks & Regards, Team@The24CarrotsInc Relevant Skills and Experience vba,excel Proposed Milestones $10 USD - Final
$10 USD in 1 day
4.9 (58 reviews)
5.8
5.8
User Avatar
I am a professional freelancer having expertise in MS Excel and I can complete your task effectively and efficiently in a timely manner. Portfolio: https://www.freelancer.in/u/KavTan.html Relevant Skills and Experience Excel, Excel Macros Proposed Milestones $50 USD - final
$50 USD in 1 day
4.8 (52 reviews)
6.0
6.0
User Avatar
Pleasure to help you. Excel automation is my masterpiece in my accounting field. Feel free to message me to start the job. Thank you so much. Relevant Skills and Experience Excel automation and accounting. Proposed Milestones $25 USD - 100% milestone and release upon completion
$25 USD in 1 day
4.8 (71 reviews)
5.5
5.5
User Avatar
Expert here to do and complete this project professionally and quickly, I have done similar projects, I can do trial work before hire me sir , will wait for your reply, Thanks, Syed Relevant Skills and Experience Excel, Excel Macros Proposed Milestones $25 USD - adv I can do trial work before hire me sir , will wait for your reply, Thanks, Syed
$25 USD in 1 day
4.7 (34 reviews)
4.7
4.7
User Avatar
This is definitely a job to automate, and it's not complicated. I could use VBA/Macros or, even better, custom software built for you to do the job. Relevant Skills and Experience Office suites (Microsoft, OpenOffice, etc.), programming (soft + web + mobile), algorithms Proposed Milestones $25 USD - Upon completion
$25 USD in 1 day
4.7 (24 reviews)
4.7
4.7
User Avatar
Relevant Skills and Experience Feel fee to contact me for. Proposed Milestones $25 USD - bidding
$25 USD in 1 day
5.0 (10 reviews)
4.2
4.2
User Avatar
Attachment missing, But description is clear, will start imm Relevant Skills and Experience Excel Proposed Milestones $20 USD - Excel
$20 USD in 2 days
5.0 (17 reviews)
3.7
3.7
User Avatar
Ican modify my existing MS Excel VBA macro to perform the function that you want. I can provide it on Monday Aug 14, 2017 Relevant Skills and Experience I have been coding in basic Proposed Milestones $20 USD - Project successfully completion
$16 USD in 0 day
5.0 (1 review)
3.4
3.4
User Avatar
Hey, can I see the current sheet? Regards, Rocky Stay tuned, I'm still working on this proposal.
$25 USD in 1 day
4.9 (3 reviews)
2.9
2.9
User Avatar
Hi. I can create auto scripts to scrape websites, auto click, format txt, csv, xls, xlsx, doc, docx, rtf, json, xml, database files as you request. I can start right now Relevant Skills and Experience I am an expert in VBA, VBScript, Visual Basic, C#, F#, C, C++, ASM, Delphi, Java, iMacros, Flash, ASP, ASP.NET, Access, MySQL, MSSQL, QuickBooks, Oracle Proposed Milestones $30 USD - complete
$30 USD in 1 day
4.2 (11 reviews)
3.4
3.4
User Avatar
Hi, I am an excel and vba specialist, I can write a macro code you need and besides the excel file I'll send you the code.
$29 USD in 1 day
5.0 (5 reviews)
2.7
2.7
User Avatar
For an accountant MS Excel is his bread and butter and so is the case with me. I have an experience of 6 years working on MS Excel and preparing Macros during my job and as a freelancer. Relevant Skills and Experience I can create Macro that will work on all the sheets. I will also add in the functionality to select which column data is to be copied and pasted in the new row. Proposed Milestones $25 USD - Completion of project
$25 USD in 1 day
5.0 (1 review)
1.9
1.9
User Avatar
I have an engineering degree in computer science. I teach advanced Excel topics to university graduates. Worked in software development in USA and New Zealand for15 years. I am interested in a long time partnership for small projects like this. I have an interest in such small projects. We can have a chat for more details.
$25 USD in 2 days
5.0 (2 reviews)
1.4
1.4
User Avatar
Excel File Readily Available With Me Relevant Skills and Experience Am an expert in excel
$25 USD in 1 day
4.5 (2 reviews)
1.2
1.2
User Avatar
sir i want to take this project. i will cler it properly. Relevant Skills and Experience i have good typing skills Proposed Milestones $20 USD - sir its k for my working accept me
$20 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, sir! (First Bidder to offer this) I hope I will be awarded from you. ************I agree for any price you will set ** You can test me over chat before you award me! give it a try over chat before you award me! .. you will be %100 satisfied I saw your project and I would like to work on it . I am available 24 hours a day and I have fast response, I will be always there to fulfill your requirement. I always offer low cost and good perfect quality (Just try and see by yourself), I will make you get 100% satisfaction with the best quality service. I will be very happy to work with you, and I hope you too. Thank you
$10 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Kissimmee, United States
5.0
5
Payment method verified
Member since Oct 17, 2016

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.