Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
display 1 line of multiple worksheets into multiple lines on 1 wks
One way ..
Assuming players' sheets are identically structured with col labels in B1:S1, eg: "Hole 1", "Hole 2", ... and with min scores calculated in row10 ie within B10:S10 (B10 for Hole 1's min score, S10 for Hole 18's). Players sheets are named as eg: Peter, Mark, etc In the summary sheet, With the same col labels placed in B1:S1 : "Hole 1", "Hole 2", ... and players' names* listed in A2 down *names listed must match exactly what's on the tabs, except for case. Watch out for any inconsistencies, eg: typos, extra white spaces, etc Place in B2: =OFFSET(INDIRECT("'"&$A2&"'!A10"),,COLUMN(A1)) Copy B2 across to S2, fill down as far as required to populate the min scores Adapt to suit. Eg just change the text "A10" to "A15" within the INDIRECT part in the formula if the min scores are in row15 (in B15:S15) instead of row10 -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Golf Nut" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Functions across multiple worksheets | Excel Worksheet Functions | |||
using multiple worksheets to do calculations | Excel Discussion (Misc queries) | |||
Adding multiple worksheets | Excel Worksheet Functions | |||
Formatting lines between data points in a line chart | Charts and Charting in Excel | |||
How to force continuous lines in line charts | Charts and Charting in Excel |