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
Bookmarks