PDA

View Full Version : Criteria based macro



cruise
04-13-2012, 12:15 PM
Dear Sriballabha,
Thanks for you continious support. I need some suggestion. Sorry to hurdle you once again.
i)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.
I change the macro but getting error.

cruise
04-15-2012, 08:38 AM
Dear all,
Can anybody help me in finding solution for this macro in excel.
Advance thanks