Populate Summary Sheet

Hello All.

I have 2 requests Im hoping you might be able to help me with.

On the INPUT sheet of my workbook I wish to search a range of rows for the first cell of each row that has data in it (starting time), and then copy the adjacent data (from cells in row 2) of each of those columns, and paste that data into respective cells on another sheet to Print.

I'd then like to do the same for the last cell filled in (finishing time).

Ive attached a part of my workbook, showing what I mean.

The data is filled in on the Input page (with the x's and the person's name), and I'd like the relevent info for the Summary page taken from that sheet and populated into it for printing.

I've filled in the start and finish times for the first three to show what I'd like to have done automatically.

I hope Ive explained it well enough and someone can be of assistance.

Thank you :-)

Something to start with:

First:

Formula:

Please Login or Register  to view this content.

Last:

Formula:

Please Login or Register  to view this content.

Hi Trevor,

Thank you so much for that.
That does just what I was after :-)

Thanks so much for that

You're welcome. Thanks for the rep.