"Mike H" wrote:

If you don't know which column this is in then it will be difficult with a
formula but if you know the column then this does it for column A

=INDIRECT("A"&SUMPRODUCT(MAX((ROW(A1:A50000))*(A1: A50000<""))))

change 50000 to a realistic likely number greater than your last row

I'll have to experiment. I may be able to do a series of columns (all will
be the same format from shhet to sheet and within a sheet) but at worst I can
plug column formulas in one by one into a single row for the sheet and then
copy that row forward to Sheet 1. Probably better that way anyway.

Thanks for your help.

Eric