Can some gurus help the below VBA module?

1. How to go to col C:E of the last used row of the active sheet?

2. How to loop through col C:E then loop again the same range but
skipping one row upwards until I find out 8 different values from the
range C:E and these 8 different values will be written in columns G:N
in the last row of the sheet.

3. The process will repeated the above procedure again from 2nd last
row until the range C:E of the 1st row of sheet have encounter.The 2nd
time loops the new 8 values will be written in the 2nd last row of
cells G:N. The 3rd time loops the new 8 values
will be written in the 3rd last row and so on.

Any help is appreciated.

Regards
Michael


---
Message posted from http://www.ExcelForum.com/