Sort data in a spreadsheet using macros and conditionals

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.

This is a one time thing - but we are starting to need work like this more and more and we would like to find a dedicated excel MASTER to handle these issues for us with the fastest TAT possible. We do not want people that will manually move things and grind it out. We need solid pros that can sort things using the most advanced techniques available on excel.

Kemahiran: Excel, Excel Macros

Lihat lagi: excel macro sort column ascending, excel sort macro button, custom sort using vba, sort macro excel, excel macro sort data multiple columns, excel vba sort column ascending, excel macro sort data dynamic range, how to create a sort macro in excel, Your program would read the data and create appropriate ADT which would then be used to store and sort the records using the hea, using macros to automate data entry, merge sort program in data structure using c, linked list algorithm in data structure using c, design a website mockup using bootstrapjs to list details of results from a web socket data source, data scraping net using macros, script sort data google spreadsheet

Tentang Majikan:
( 4 ulasan ) Kissimmee, United States

ID Projek: #14911299

52 pekerja bebas membida secara purata $23 untuk pekerjaan ini


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 dalam sehari
(216 Ulasan)

HI, I have over 7 years of advanced excel [login to view URL] this site, I have completed over 150 Excel related projects. I am available now to work on your project . Thanks Relevant Skills and Experience I have over 7 y Lagi

$28 USD dalam sehari
(189 Ulasan)

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 Exp Lagi

$25 USD dalam sehari
(120 Ulasan)

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 ex Lagi

$30 USD dalam sehari
(221 Ulasan)
$35 USD dalam sehari
(30 Ulasan)

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 Lagi

$25 USD dalam sehari
(62 Ulasan)

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 Experien Lagi

$50 USD dalam sehari
(37 Ulasan)

I can provide cleaned workbooks using a variety of tools, including macros, Power Query and regular expressions. See my portfolio. Relevant Skills and Experience I have built automated systems in Access, Excel and VB. Lagi

$22 USD dalam sehari
(14 Ulasan)

please send the file, I can send first draft for test within 12-14h since now

$30 USD dalam sehari
(12 Ulasan)

Your task is clear to me and I am ready to execute the project for the 25 USD. Relevant Skills and Experience Your task is solved. [login to view URL] Proposed Milestones $25 Lagi

$25 USD dalam 0 hari
(31 Ulasan)

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 an Lagi

$10 USD dalam sehari
(44 Ulasan)

Hi Mr. Employer I have lot of experience in excel spreadsheet and I can do this project in effective manner with 100% accuracy report to your requirements. See Below video as my earlier work with Excel . Recipes Mana Lagi

$30 USD dalam sehari
(35 Ulasan)

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 Exc Lagi

$25 USD dalam sehari
(29 Ulasan)

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, Lagi

$25 USD dalam sehari
(20 Ulasan)
$20 USD dalam sehari
(9 Ulasan)

Attachment missing, But description is clear, will start imm Relevant Skills and Experience Excel Proposed Milestones $20 USD - Excel

$20 USD dalam 2 hari
(14 Ulasan)
$20 USD dalam 2 hari
(11 Ulasan)
$25 USD dalam sehari
(13 Ulasan)

Relevant Skills and Experience Feel fee to contact me for. Proposed Milestones $25 USD - bidding

$25 USD dalam sehari
(3 Ulasan)

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 - Proje Lagi

$16 USD dalam 0 hari
(1 Ulasan)