Quick vowel sorter spreadsheet macro

Completed Posted 6 years ago Paid on delivery
Completed Paid on delivery

I have lists of words that need to be combined into single lists, based on the vowel sound in the beginning. See attached image for the way the spreadsheet looks. Essentially, I need a macro that will allow me to enter the columns I want to have copied and combined into 2 lists, one with the words that begin with consonant sounds, and another with words that begin with vowel sounds. To do this, the macro will simply start by sorting all of the words that begin with A, E, I, or U into column C of sheet 3 and all other words into sheet B, BUT there will be a list of exceptions on the second sheet, with words such as "Europe," which begin with an E, but begin with a consonant sound, so they will be treated as consonants, and put in column B.

If, based on the image, you're confident you can do this, let me know, and I'll send the spreadsheet I'm using for it. Thanks!

Data Processing Excel Visual Basic Visual Basic for Apps

Project ID: #16473611

About the project

16 proposals Remote project Active 6 years ago

Awarded to:

AnumZia

I'm Ready It does not matter how much you pay after the work is finally delivered We will work on it now I will deliver you the same day Quick execution Dealing seriously Work 24 hours a day Relevant Skills More

$25 USD in 0 days
(15 Reviews)
4.3

16 freelancers are bidding on average $42 for this job

bouslimi1979

Hi, I ll code the macro for you. Let's start. Thanks ************************************************************************************************

$50 USD in 1 day
(288 Reviews)
7.7
tiaratechies

Hello, being an excel expert with proven expertise and certified from Microsoft, we can give you the best solution.

$250 USD in 1 day
(51 Reviews)
6.9
vano101

Hello I have extensive experience with coding simple Excel macros And this macro looks as piece of cake.

$21 USD in 1 day
(368 Reviews)
6.5
khudammunir

Hi I would like to bid for this project. I posses Data Analytics, Research, Accountancy, Administration, Banking, Financial/Business Analysis & Reporting and Content Writing experience with Advance MS Excel Dashboards, More

$25 USD in 1 day
(32 Reviews)
5.6
user2690

Hi, good day. I'd like to help you with this macro. I can do a demo if you send me a file with few data, then I'll show you via teamviewer

$18 USD in 2 days
(4 Reviews)
2.1
Twinkaii1995

My skill set includes successfully inputting information from various sources into computer systems for archival and analysis purposes. Furthermore, I possess expertise in identifying and resolving inconsistencies, uti More

$25 USD in 2 days
(0 Reviews)
0.0
jeb1248

Just to be clear: You want all of the words on Sheet1 that begin with the letters A, E , I or U to be copied to Sheet3 column "C"; All words NOT beginning with the letters A, E , I or U on Sheet1 copied to Sheet3 colum More

$30 USD in 2 days
(0 Reviews)
0.0
QSPfreelance

Hi. I'm new at this site, but i have good excell and VBA skills. At now i'm working as an economist and looking for a new experience. I can do this project for you.

$25 USD in 1 day
(0 Reviews)
0.0
muez325

Dear Sir/Mam I hope you are in good health condition. Before I say something about myself, I would like to thank you very much for the job posting. After I studied your job posting on “Data Entry”, if I'm right, acco More

$25 USD in 1 day
(0 Reviews)
0.0