Excel Spreedsheet Formating and Macro

Closed

see file attached for reference.

I need the following done. On the attachment the data with no fill is the original and the couloured filled rows are what i need it turned into. I don't require the original to remain in the document.

Excel Version 2007

I need a macro or code for a rule to do the following.

> Delete rows that dont contain the key phrashes in column B "Extension" or "House in DPC"

> Create a new column with the content from column c formatted from the below

"number" "street name" "type" "suburb" "state" "post code" please note they will always appear in this order when copied in, there will not be any extra or less.

to

Column C > "number" "street name" "type" (Formatted with first letter of each word as a capital)

Columb D > "suburb" "state" "post code" (formatted with capital letters)

That date that appears in column D should also be deleted as it is not required.

Looking to hire asap.

Skills: Data Entry, Data Processing, Excel

See more: reference letters, new hire letter, letters of reference, first capital, excel macro to word, data entry macro, what is macro in excel, create macro in word, macro, Hire Excel, delete attachment, order processing require, excel number word, number word excel, 2007 word macro, create word document excel macro, excel macro reference, word extension, macro excel create word, excel fill, need asap letter, excel create macro, macro data entry, create document excel file, create word document macro excel

Project ID: #2691893

27 freelancers are bidding on average $60 for this job

hossionsumon

Hello sir,Experts team here Check my sample

$30 AUD in 0 days
(150 Reviews)
6.7
sy3d

Consider it done .. check pm .. thx

$66 AUD in 0 days
(152 Reviews)
6.4
danielgpratidya

Hi, I am DONE and sure the attach XL file will work as you could imagine complete with the Error Handler. I am a "all the time" 5 stars awarded freelancer and have never failed even for a single project. Feel free to More

$30 AUD in 0 days
(98 Reviews)
6.0
sonarkaushik

Sir, I can do the project. Refer PMB. with regards

$69 AUD in 2 days
(66 Reviews)
5.9
emon97

I am ready to do this for you, please refer to PM for details

$61 AUD in 2 days
(68 Reviews)
5.7
harubel

Excel Expert is here to assist you.

$120 AUD in 3 days
(29 Reviews)
5.6
rajeshsonisl

Quality work assured. Ready to get started. Thanks.

$250 AUD in 1 day
(71 Reviews)
5.5
macejd

Hi ENVY01, I am interested in your project. Please check your PM for my solution proposal.

$60 AUD in 2 days
(21 Reviews)
5.3
Krusche

Consider it done. We will deliver the solution within several hours after we officially start. Please check your PMB.

$33 AUD in 0 days
(20 Reviews)
5.2
NiceDeveloper

Hi, We aim to provide you the best quality work. See more detail in PMB Thanks

$80 AUD in 2 days
(7 Reviews)
4.7
expertatwork

Good morning ENVY01 ! Very confident and comfortable team here ! Please award us the work. thanks in advance !!

$30 AUD in 0 days
(39 Reviews)
4.4
microk

Expert here. Please check PM..

$30 AUD in 2 days
(23 Reviews)
4.4
vgrichards

Have seen and understood the requirement. Very Good at Excel 2003-2010 and Excel VBA Macros. Please allow me to do it. Will ensure everything is as per your requirement

$30 AUD in 2 days
(24 Reviews)
4.0
him76

its ready, pls check pm.

$30 AUD in 0 days
(15 Reviews)
4.0
vikashgadia

lets finish ur project now..

$35 AUD in 1 day
(15 Reviews)
3.6
farr4u

HI, VBA expert here, i understood your work and have alreadt created the solutions your need with additional features. Plz chk PM.

$30 AUD in 0 days
(14 Reviews)
3.5
afua23

I can get this done for you. I am an excel expert

$90 AUD in 1 day
(18 Reviews)
3.6
dxxd116

I am an expert in excel macro development. Looking forward to working on this project.

$100 AUD in 2 days
(2 Reviews)
3.1
benefitworks

Hi Greeting!!! Just an couple of hours work. got 5 start from Australian client. See reviews. Regards, Karim

$30 AUD in 0 days
(3 Reviews)
2.5
sumshank

Thanks for your time in reading my bid. Here is what I can offer: - Excellent MS Excel skills, having used it extensively during my work with the Information Technology industry. - My Excel work includes usage of More

$70 AUD in 1 day
(3 Reviews)
2.4