Dear fnd,
I want the output in red font of spreadsheet. I have already written the macro for that.
Doubt:--------------
when I change the output criteria from G2 to H23 or any cell, then output seems jumbled.(As to the end of table, some data are there). Can it possible to rectify.
ii)Is it possible to keep one blank cell below in excel that means after every two criteria, I want .
iii) Can we change the value of zero record to 'No cases' (as in excel)
iv) Is it possible to give some color to extra unmatched record (Sales/Baylish/13000/India/20=1, Clerk/ADAM/10000/India/20=3)
v)The last record in table i.e. total should be skipped from output.
http://www.2shared.com/file/6IJ6bzdq/1_online.html
I want the output in red font of spreadsheet. I have already written the macro for that.
Doubt:--------------
when I change the output criteria from G2 to H23 or any cell, then output seems jumbled.(As to the end of table, some data are there). Can it possible to rectify.
ii)Is it possible to keep one blank cell below in excel that means after every two criteria, I want .
iii) Can we change the value of zero record to 'No cases' (as in excel)
iv) Is it possible to give some color to extra unmatched record (Sales/Baylish/13000/India/20=1, Clerk/ADAM/10000/India/20=3)
v)The last record in table i.e. total should be skipped from output.
http://www.2shared.com/file/6IJ6bzdq/1_online.html