find the row

[g48dd]

Hi, I am using Excel 2003, I have 30 tabs in a workbook. Each worksheet has 200 names or more in a list. I am going to use CONSOLIDATE to move all the data to one worksheet, but before I do I need to make sure that the name on line 1 sheet 1 is the same name on line 1 sheet 2 all the way through all the 30 tabs. I tried sorting but some worksheets are longer than others. Can I use the ROW Function in some way to check that the name "Dog" which appears on line 5 sheet 1 is also on line 5 Sheet 2, Line 5 Sheet 3 ect....?

Thanks
Ken

[Palmetto]

If you intent is to check just the one cell, say A5, on all sheets then, perhaps this will work for you.

Please Login or Register  to view this content.