I want to search for an item in one column (let's say Column D).
I then need to 'cascade that search' by searching from the row found
with the first search to the end of the sheet's used area, but this
time in Column A. Any ideas?

(The basic problem is that Column D has (let's say) Monday in 48 rows,
Tuesday in 76 rows, Wednesday in 29 rows, etc. Column A has various
numeric values and the values for the Mondays are the same as 48 of the
Tuesday values. I need to pick up the row number so I can compare the
value in one row with the corresponding value in another workbook.)


--
PeterB
------------------------------------------------------------------------
PeterB's Profile: http://www.excelforum.com/member.php...o&userid=20288
View this thread: http://www.excelforum.com/showthread...hreadid=494595