This is my first time, and I am fairly new to Excel so I hope to become as expert as you guys seem to be!
I have Sheet 1 with a 3 column table. Col1 contains sorted names and the each name can be repeated up to 9 times. (i.e. could be from 1 to 10 rows per name) Col2 is irrelevant but Col3 has free form text comments.
In sheet 2 I have a table with Col 1 having the same names as Sheet 1 every 10 rows. The intervening Col 1 cells are blank.
In column 4 I wish to show the related comments, in the same order, from Sheet 1.
Office/Excel 2000 and Win XP Pro.
Help would be VERY much appreciated.
I have Sheet 1 with a 3 column table. Col1 contains sorted names and the each name can be repeated up to 9 times. (i.e. could be from 1 to 10 rows per name) Col2 is irrelevant but Col3 has free form text comments.
In sheet 2 I have a table with Col 1 having the same names as Sheet 1 every 10 rows. The intervening Col 1 cells are blank.
In column 4 I wish to show the related comments, in the same order, from Sheet 1.
Office/Excel 2000 and Win XP Pro.
Help would be VERY much appreciated.
