In Progress

Excel Email

Hi :

I want to have a macro for excel file. The file is attached. It should do the following

Order below is not necessary

1). Sort out the file by amount i.e if amount i have is >2000 or < 2000 , highlight the whole row . Amount could be any

2). Sort out by specific word i.e if INTERST etc , the whole row must be highlighted

3). For those parties, who has amounts > 2000 or < 2000 ( again amount could be anything) , highlight the whole row .The short name of CTPTY (in column A ), must become hyperlink , which then search for that CTPTY email address ( among various others possibly from central file ), and opens the email which to be sent to them

there will be some wording in columns B ,G ,H.I(not numbers) .

Let me know if you can do this. This is an easy stuff if one knows vb/excel. This project might get enhanced .

e.g

ctpty currency amount ref1 ref2 pmt method productype

ABCD xyz 2000 1234 1235 pay interest

J

Skills: Data Entry, Data Processing, Excel, Visual Basic

See more: me excel, n excel, email g, wording, vb excel, sort excel, search email, row b, ref2, macro excel, macro e, highlight, get email, email search, do excel, excel macro sort, sort macro, excel specific, excel row column, excel macro row, word macro basic, visual basic currency, excel column row, want email project, enhanced

About the Employer:
( 0 reviews ) Toronto, Canada

Project ID: #219574

Awarded to:

carlestops

See my attachment it's as good as done

$30 USD in 0 days
(0 Reviews)
0.0

26 freelancers are bidding on average $37 for this job

MAnkita

Hello,Please refer your PMB.Thank you.

$50 USD in 1 day
(132 Reviews)
6.5
riyoyo

Where is the attachment, Sir? So I could estimate the final price?

$30 USD in 0 days
(12 Reviews)
5.6
azhu

Dear Sir Kindly see your PM for details. Thanks AZHU

$30 USD in 2 days
(1 Review)
2.4
singular

Hi! I'm from Montreal and I specialize in MS Office Automation. I'd be glad to do this job for you. Payments through GAF's escrow service.

$30 USD in 1 day
(0 Reviews)
0.0
nithyasiva

Hi, See my PM

$30 USD in 1 day
(0 Reviews)
0.0
shanecox704

this is no problem!

$30 USD in 10 days
(0 Reviews)
0.0
adkandey

give work and take as your hope.

$30 USD in 1 day
(0 Reviews)
0.0
piyushpv

Hi Best Price, Best Work, Best Team. only 1 Hr.

$30 USD in 1 day
(0 Reviews)
0.0
Ready4work

Check our profile

$30 USD in 1 day
(0 Reviews)
0.0
rmonica25

Dear Sir, We wish to bid this project , i wish to make you sure also we will accomplish the assignment with in the time frame. Regards

$50 USD in 7 days
(0 Reviews)
0.0
walterwty

I'm looking forward to work with you.

$30 USD in 1 day
(0 Reviews)
0.0
garima007

i would like to do this project & assure u efficient work

$30 USD in 3 days
(0 Reviews)
0.0
andarservice

Hi there, Try me, I will sort out your problem on time

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

i would like to do this project

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

Sir, I can do the work. Regards,

$30 USD in 1 day
(0 Reviews)
0.0
kamlanand

Dear Sir, I have very good exprience in excel and data entry. I am looking for this type of project. thanks kamlanand

$50 USD in 3 days
(0 Reviews)
0.0
albain

Please provide the attachement so I can start

$30 USD in 2 days
(1 Review)
0.0
nikhilrao123

Hi, I am an experienced analyst and I use excel every day at work. I can get this done for you easily. Please see PMB for more details. Regards.

$40 USD in 1 day
(0 Reviews)
0.0
kasturikrishnan

kindly refer pm box for a message

$100 USD in 3 days
(0 Reviews)
0.0
armkakohr

Looking forward to working with you. Kindly check your PM. Looking forward to be considered for this Abbas

$30 USD in 3 days
(0 Reviews)
0.0