Do you want the address of the next non-empty cell or the value contained in
the next non-empty cell?

I take it C5 is the beginning of the range and you want to find the next
cell below that that is not empty. What type of data is it, text, numeric,
both?

You mentioned 6 sheets. Will there always be 5 entries in this range? Are
any of the entries duplicates?


--
Biff
Microsoft Excel MVP


"Pierre" wrote in message
ups.com...
Need a formula to identify the next non-empty cell in a column. This
reference woud be used on another worksheet to do lookups against.

Sheet 1 would have a value in cell C5. The next populated cell in
column C on sheet 1 would be C13.
On sheet 2, I'd like to identify that C13 is the starting point and so
on. This would continue for up to 6 sheets, with sheet 3, finding the
next non-empty cell after the one it found in sheet 2 C13, (sheet 3
finding the next non empty cell after C13 that it sound for sheet 2,
lets say C22 from sheet 1 and each subsequent sheet identifying the
next non empty cell in the sequence from sheet 1.

Ideas?

Thanks in advance.

Pierre