How would you create this summary page?

[map985]

Hello,
I have three worksheets. All are setup the same, with dates in the left column. Each row contains several columns with values for that day. How would you make a summary page that displays only the row for today (or which ever date is typed into the left column), for each worksheet? I have attached the file.

Thanks in advance for any help!

Flight duty times1.02 example.xlsx

[noboffinme]

Hi, could you mock up a worksheet displaying how you would like to see the latest data?

Thanks

[map985]

Hi,
thanks for the reply! In the attached file, I made up a worksheet called summary. It's laid out pretty much the same as the other worksheets labeled 'Pilot', except it has a column in the left for 'Pilot'(in this case they are numbered 1,2,3. I was hoping to be able to have the row, based on the worksheet it represents(pilot, Pilot2, Pilot3, etc.), show the data in the corresponding cells in that row for today's date(or which ever date is entered) from the worksheet. This way, Instead of looking through each worksheet to see what the values are for the day, they will all be represented on one worksheet. I have three worksheets labeled 'pilot' but plan on expanding that to 12 once I understand how to make up the summary worksheet as described.

Thanks again!

[ThirtyTwo]

a vlookup seemed to do the trick

Please Login or Register  to view this content.

copy and paste formula across the rest of the table

=VLOOKUP( ..............
$B4, ................... what we're looking up, the date entered on the summary sheet
INDIRECT( .............. INDIRECT function allows us to make changes to the range it is going to use
"'Pilot (" ............. Setting the sheet name for each pilot
&$A4 ................... The pilot is numbered in column A, 1 to 3
&")'!$A$4:$M$1098") .... The rest of the range is fixed
,COLUMN()-1 ............ From the lookup array, which column of data to return, instead of entering 2, 3, 4, etc use column() to
........................ give us a number, makes it easier for copying and pasting the formula across the rest of the table
,FALSE) ................ tell it you want an exact match on the date you are looking up

[map985]

Thanks ThirtyTwo, this is great!