En cours

Excel Template

Template required in Excel that includes macros and VB to format spreadsheet. Please see the file attached, the first tab (data) contains the original data and the second tab (output) the desired results.

Template must contain the current headers on the first tab and a format button built in VB. Once the data is pasted in and the format button is clicked the desired results should appear on a new sheet (2nd tab)

First tab (data) formatting includes -

Street field - street number must be separted from street name.

Street field - If the cell contains a "-" in the street name it must be replaced by " ".

Street field - remove the world "Lot" please see tab 2 output for example.

Surname field and Initial field must be merged - =intial&" "&surname.

Address would need to be de-duplicated and the final address contains the phone numbers. Please see the highlighted cells in the second tab (output).

This template will be used on a ongoing basis.

Compétences : Excel

Voir plus : name and address template excel, vb in excel, new excel, vb excel, format excel, Excel Formatting, excel sheet formatting, excel contains, spreadsheet template, need spreadsheet built, excel format cell, excel cell format, excel cell, format cell, file name excel, merged, address excel format, street address spreadsheet, street address excel, need excel macros, macros template, excel numbers, excel button, need phone numbers excel, tab format

Concernant l'employeur :
( 3 commentaires ) Blair Athol, Australia

N° du projet : #1019048

26 freelance font une offre moyenne de $60 pour ce travail

diamond247

######For this type of work we are maven, See the PM for detail#######

30 $ USD en 0 jours
(52 Commentaires)
5.9
nagybatonyi

Such jobs are my daily practice, please see PMB for details! Regards!

40 $ USD en 2 jours
(51 Commentaires)
5.7
z0mbie

I've seen your file and already got solution which can be implemented within an hour or two. Best regards.

100 $ USD en 1 jour
(1 Commentaire)
2.4
emce75

Hi, can do this quickly, however need some additional clarification about some clearing rules (regarding Lot removal and de-duplicates criteria as there could be some risks of misleading)

30 $ USD en 0 jours
(1 Commentaire)
1.8
kanadyanako

Kindly read my PM.

30 $ USD en 0 jours
(1 Commentaire)
1.8
HazelX

Sent you a PM.

40 $ USD en 2 jours
(1 Commentaire)
1.3
Siddharth0

pls see pm

30 $ USD en 2 jours
(0 Commentaires)
0.0
Mostafaertu

check my pm

30 $ USD en 3 jours
(0 Commentaires)
0.0
ITProgramming

Hello sellforce, I work as a project controller and have to do similar jobs very often. If you decide for me, you can be sure to get a very good tool. Best wishes, ITProgramming

39 $ USD en 2 jours
(0 Commentaires)
0.0
rmjudkins

Your project is ready for delivery. Please see PM. For the past decade my focus has been spreadsheet development within Excel utilizing VBA programming. During this time I have developed spreadsheet applications by Plus

250 $ USD en 1 jour
(0 Commentaires)
0.0
travcarp1

I have done projects similar to this in the past. I'm new to Freelancer, and I'm looking to complete my first project. This should take no longer than a few hours, so $40 is a pair price.

40 $ USD en 2 jours
(0 Commentaires)
0.0
prakasha14683

I like to go ahead.

100 $ USD en 5 jours
(0 Commentaires)
0.0
hatemkhalil

Excellent accuracy and finish in no time.

30 $ USD en 1 jour
(0 Commentaires)
0.0
deeudeec

I will do this job super quickly. VBA is my favorite mode of programming.

30 $ USD en 1 jour
(1 Commentaire)
0.0
EXCELPROBG

I can do this in no time.

30 $ USD en 0 jours
(0 Commentaires)
0.0
gufran675

Dear/Madam,Sir I'm applying for this project, kindly give me if possible I'll do it withing three days. Thanks & Best Regard

45 $ USD en 3 jours
(0 Commentaires)
0.0
v15441

Please check PMB

30 $ USD en 1 jour
(0 Commentaires)
0.0
mahbub032

Dear sir I want to this job. I have 5 years working exp. in ms word and ms excel. Thanks

150 $ USD en 10 jours
(0 Commentaires)
0.0
Shobhaasathish

I would like to do this for you.. See PM

50 $ USD en 4 jours
(0 Commentaires)
0.0
ksabev

Quick & efficient

35 $ USD en 1 jour
(0 Commentaires)
0.0