Need to validate and copy the output into new sheet.

Hi Excelperts,

I am bala and i am new to this Forum. Basically i am a mainframe developer and have no clue about Excel Macros. But i have 1 request and need to resolve it ASAP. Would like you people to assist me in this and it will be really grateful.

Request is: We used to get the excel sheet which contains 9 columns with several values associated with it. Now what we are supposed to do is validation using macros. Conditions for the associated columns are mentioned below.

Note: It can be of lakh or million rows. Need to process till the empty row.

column 1: It should hold the value as always 3 (either text or integer)
column 2: It should hold the value as A, B, C and D
column 3: It should hold the value always Greater than zero.
column 4: It should hold the value be TRUE
column 5: It should hold the value be Y or N.
column 6: It should hold the value which is not equal to D or N
column 7: It should hold the value as zero
column 8: It should hold the value as always 5 (either text or integer)
column 9: It should hold the value be Y or N.

Out of this 9 column validation, if any of the condition not satisfies we going to skip that row.

Please let me know, how to incorporate this changes in MACROS..