View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Golf Nut Golf Nut is offline
external usenet poster
 
Posts: 2
Default display 1 line of multiple worksheets into multiple lines on 1 wks

I have a workbook with individual worksheets for multiple people. Each sheet
has rows and columns of information then a summary row that displays the
minimum in each column. i want to create a consolidated worksheet that
displays this one line of information for each person. The workbook is of
golf scores for a league displaying actual scores for each hole on different
dates. It calculates the lowest score for each hole. I am trying to
summarize all the worksheets into one that shows the lowest score on each
hole for each person.