Đang Thực Hiện

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.

Kỹ năng: Excel

Xem thêm: 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

Về Bên Thuê:
( 3 nhận xét ) Blair Athol, Australia

Mã Dự Án: #1019048

26 freelancer đang chào giá trung bình $60 cho công việc này

diamond247

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

$30 USD trong 0 ngày
(52 Đánh Giá)
5.9
nagybatonyi

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

$40 USD trong 2 ngày
(51 Đánh Giá)
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 trong 1 ngày
(1 Đánh Giá)
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 trong 0 ngày
(1 Đánh Giá)
1.8
kanadyanako

Kindly read my PM.

$30 USD trong 0 ngày
(1 Đánh Giá)
1.8
HazelX

Sent you a PM.

$40 USD trong 2 ngày
(1 Đánh Giá)
1.3
Siddharth0

pls see pm

$30 USD trong 2 ngày
(0 Đánh Giá)
0.0
Mostafaertu

check my pm

$30 USD trong 3 ngày
(0 Đánh Giá)
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 trong 2 ngày
(0 Đánh Giá)
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 Thêm

$250 USD trong 1 ngày
(0 Đánh Giá)
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 trong 2 ngày
(0 Đánh Giá)
0.0
prakasha14683

I like to go ahead.

$100 USD trong 5 ngày
(0 Đánh Giá)
0.0
hatemkhalil

Excellent accuracy and finish in no time.

$30 USD trong 1 ngày
(0 Đánh Giá)
0.0
deeudeec

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

$30 USD trong 1 ngày
(1 Đánh Giá)
0.0
EXCELPROBG

I can do this in no time.

$30 USD trong 0 ngày
(0 Đánh Giá)
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 trong 3 ngày
(0 Đánh Giá)
0.0
v15441

Please check PMB

$30 USD trong 1 ngày
(0 Đánh Giá)
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 trong 10 ngày
(0 Đánh Giá)
0.0
Shobhaasathish

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

$50 USD trong 4 ngày
(0 Đánh Giá)
0.0
ksabev

Quick & efficient

$35 USD trong 1 ngày
(0 Đánh Giá)
0.0