Assuming that there is some type of data in column A, could do:
=INDEX(2:2,,COUNTA(2:2))

Otherwise,
=INDEX(B2:Z2,,COUNTA(B2:Z2))
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Melissa" wrote:

I have an Excel worksheet with 2 sheets. Sheet1 is for data entry and will
have data in columns to record details of meetings, each row is a different
person e.g. column B has details of first meeting, column C has details of
second meeting, column D has details of third meeting and so on .

I want my second sheet to be a report that shows the details of the most
recent meeting i.e I want a formula in sheet2 that looks at sheet1, finds the
last cell in a row with text, and copies this text to the relevant cell in
sheet2. Do I use "go to" command plus a formula? how?