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 .
ctpty currency amount ref1 ref2 pmt method productype
ABCD xyz 2000 1234 1235 pay interest