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, excel macro to word, excel &, vb in excel, n excel, email g, wording, vb excel, sort excel, search email, row b, ref2, macro excel, macro e, macro + excel, Highlight, get email, excel\ , excel, excel c#, email search, do excel, excel macro sort, sort macro, excel specific

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 [url removed, login to view] 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