Hi ppl,

Before proceeding with my question lemme give you the following information

1) OS:- Windows xp
2) Excel version :- 2003

Ok here goes,

Now suppose I have some data already present in Sheet 2 of excel, say cells A1 to A10. I want these cells to be copied and pasted one by one to cell A1 in Sheet 1 , wherein the cell A2 in Sheet 1 checks a certain condition and displays the result as "YES" or "NO".
Now I want a summary of this "YES" or "NO" for the values pasted in cell A1, Sheet 1 (10 times in a cycle) to be pasted in Sheet 3 in consecutive columns from cell A1.

How to go about doing this. Any help is appreciated.

Regards,
Debayan