Excel Email

Excel Email is project number 219574 posted at GetAFreelancer.com. Click here to post your own project.

Status:	Closed (Selected Service Provider)
Selected Providers:	selected service provider carlestops
Budget:	$30-250
Created:	01/29/2008 at 18:57 EST
Bidding Ends:	02/01/2008 at 18:57 EST
Project Creator:	jiggskt   Buyer Rating: (No Feedback Yet)
Description:	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
Job Type:	Data Entry Data Processing Excel Visual Basic
Database:	(None)
Operating system:	MS Windows
Bid count:	26
Average bid:	$ 37