gvreddyhr
10-31-2011, 10:11 PM
Hi,
Thanks for your ultimate support for my earlier posts, now I require small help in writing code using if, below is the scenario
Ex:- I have sheet1 with full salary details(Xl down), A1 – Emp Number, B1-Emp name, C1 – Gross Salary,D-1 Basic Salary,E1 – HRA,F1-Others,G1-PF,H1-ESI, in sheet2, I have created heads as A1-Emp Name,B1-Emp Nmae,C1-Gross Salary, D1-ESI, now I want to write a code, referring to sheet1 if ESI amount is > 0, then only those applicable employee details should furnish in sheet2.
Can anyone help me in writing the code for this.
Thank you so much in advance.
Regards,
GV Reddy
Thanks for your ultimate support for my earlier posts, now I require small help in writing code using if, below is the scenario
Ex:- I have sheet1 with full salary details(Xl down), A1 – Emp Number, B1-Emp name, C1 – Gross Salary,D-1 Basic Salary,E1 – HRA,F1-Others,G1-PF,H1-ESI, in sheet2, I have created heads as A1-Emp Name,B1-Emp Nmae,C1-Gross Salary, D1-ESI, now I want to write a code, referring to sheet1 if ESI amount is > 0, then only those applicable employee details should furnish in sheet2.
Can anyone help me in writing the code for this.
Thank you so much in advance.
Regards,
GV Reddy