Açık

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.

Beceriler: Excel, Excel Macros

Daha fazlasını görün: 2008 extract data spreadsheet, data mining using aspnet, data entry using spss

İşveren Hakkında:
( 2 değerlendirme ) Kissimmee, United States

Proje NO: #14911299

52 freelancer bu iş için ortalamada 23$ teklif veriyor

P0L

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.

1 gün içinde 30$ USD
(180 Değerlendirme)
6.7
MimiFL

Macro to split each row with multiple data fields (email and phone) into separate rows each containing only one piece of information. Relevant Skills and Experience I m serious freelancer with 100% completion rate and Daha fazlası

in 0 gün içinde25$ USD
(284 Değerlendirme)
6.3
mrbrave

HI, I have over 7 years of advanced excel experience.On 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 Daha fazlası

1 gün içinde 28$ USD
(187 Değerlendirme)
6.5
TonmoyRoy111

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 Daha fazlası

1 gün içinde 30$ USD
(191 Değerlendirme)
6.1
ksriniravi

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 Daha fazlası

1 gün içinde 25$ USD
(79 Değerlendirme)
5.9
1 gün içinde 35$ USD
(28 Değerlendirme)
5.1
KavTan

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 Daha fazlası

1 gün içinde 50$ USD
(34 Değerlendirme)
5.1
parsermonster

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. Daha fazlası

1 gün içinde 22$ USD
(14 Değerlendirme)
4.8
renesontiongson

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 Daha fazlası

1 gün içinde 25$ USD
(45 Değerlendirme)
4.9
The24CarrotsInc

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 Daha fazlası

1 gün içinde 10$ USD
(32 Değerlendirme)
4.7
AlexandrUKR

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

1 gün içinde 30$ USD
(10 Değerlendirme)
4.8
royalcalif

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 Daha fazlası

1 gün içinde 30$ USD
(28 Değerlendirme)
4.4
SShtv

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. https://drive.google.com/open?id=0B-zZiMZzrxMBZDJRV1dsbWl3UkE Proposed Milestones $25 Daha fazlası

in 0 gün içinde25$ USD
(20 Değerlendirme)
4.5
crazynightwalker

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, Daha fazlası

1 gün içinde 25$ USD
(19 Değerlendirme)
4.1
in 2 gün içinde20$ USD
(9 Değerlendirme)
3.7
1 gün içinde 20$ USD
(9 Değerlendirme)
3.7
adilsyed123

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 Daha fazlası

1 gün içinde 25$ USD
(23 Değerlendirme)
4.0
1 gün içinde 25$ USD
(11 Değerlendirme)
3.3
abbalove

Hey, can I see the current sheet? Regards, Rocky Stay tuned, I'm still working on this proposal.

1 gün içinde 25$ USD
(2 Değerlendirme)
2.9
HaykDag

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.

1 gün içinde 29$ USD
(5 Değerlendirme)
2.8