I have a large excel workbook with 12 worksheets for the months. In these
worksheets are up to 150 names with log book violations listed (we are a
trucking company). there are actually 5 colums of information for each
driver. I would like to consolidate this information at years end to see who
the main violators are. Is there any way to consolidate this data across
multiple worksheets into one easy to read worksheet?

yes their are a few and varied ways of doing this. but it really depends on
how your data is presented on the "months pages" and what you want to see on
the final report, are the 5 colums of data numbers of violations or text !!!
it really does depend on the current layout and what you hope to end up with

Rich


"Joe H" wrote:

I have a large excel workbook with 12 worksheets for the months. In these
worksheets are up to 150 names with log book violations listed (we are a
trucking company). there are actually 5 colums of information for each
driver. I would like to consolidate this information at years end to see who
the main violators are. Is there any way to consolidate this data across
multiple worksheets into one easy to read worksheet?

Thanks for your reply. I will try to answer your questions:

The names are in text and the violations are in numbers. My spreadsheet is
set up with headers listing the various violations and has the Drivers Name
column . There are more things in this spreadsheet, but the only data that I
want consists of 5 columns of numbers plus the names.

I hope to end up with a monthly view of who is getting the violations and
what type of violation they are.

"Rich Mcc" wrote:

yes their are a few and varied ways of doing this. but it really depends on
how your data is presented on the "months pages" and what you want to see on
the final report, are the 5 colums of data numbers of violations or text !!!
it really does depend on the current layout and what you hope to end up with

Rich


"Joe H" wrote:

I have a large excel workbook with 12 worksheets for the months. In these
worksheets are up to 150 names with log book violations listed (we are a
trucking company). there are actually 5 colums of information for each
driver. I would like to consolidate this information at years end to see who
the main violators are. Is there any way to consolidate this data across
multiple worksheets into one easy to read worksheet?

"Joe H" wrote:

Thanks for your reply. I will try to answer your questions:

The names are in text and the violations are in numbers. My spreadsheet is
set up with headers listing the various violations and has the Drivers Name
column . There are more things in this spreadsheet, but the only data that I
want consists of 5 columns of numbers plus the names.

I hope to end up with a monthly view of who is getting the violations and
what type of violation they are.

"Rich Mcc" wrote:

yes their are a few and varied ways of doing this. but it really depends on
how your data is presented on the "months pages" and what you want to see on
the final report, are the 5 colums of data numbers of violations or text !!!
it really does depend on the current layout and what you hope to end up with

Rich


"Joe H" wrote:

I have a large excel workbook with 12 worksheets for the months. In these
worksheets are up to 150 names with log book violations listed (we are a
trucking company). there are actually 5 colums of information for each
driver. I would like to consolidate this information at years end to see who
the main violators are. Is there any way to consolidate this data across
multiple worksheets into one easy to read worksheet?

you could have a 13th sheet which = totals this would be the same layout as
your other sheets but with only the colums which you want showing \ included

lets say, fred flistone is in cell a5.. in b5 just use a simple add
formula.. there are other options ideas , but this is a simple one,, and not
as daunting as it may sound, because you would only have to insert the
formula into the one cell on page 13,,

tell it to add the other 12 corrosponding cells together,,,
=sum(Sheet2!B5,Sheet3!B5,Sheet4!B5,Sheet5!B5) ect then one it is adding all
12 pages copy and paste the formula down col ),, this of course assumes that
the same driver is in the same row on every page


"Joe H" wrote:

Thanks for your reply. I will try to answer your questions:

The names are in text and the violations are in numbers. My spreadsheet is
set up with headers listing the various violations and has the Drivers Name
column . There are more things in this spreadsheet, but the only data that I
want consists of 5 columns of numbers plus the names.

I hope to end up with a monthly view of who is getting the violations and
what type of violation they are.

"Rich Mcc" wrote:

yes their are a few and varied ways of doing this. but it really depends on
how your data is presented on the "months pages" and what you want to see on
the final report, are the 5 colums of data numbers of violations or text !!!
it really does depend on the current layout and what you hope to end up with

Rich


"Joe H" wrote:

I have a large excel workbook with 12 worksheets for the months. In these
worksheets are up to 150 names with log book violations listed (we are a
trucking company). there are actually 5 colums of information for each
driver. I would like to consolidate this information at years end to see who
the main violators are. Is there any way to consolidate this data across
multiple worksheets into one easy to read worksheet?

Thank you-I will look at that option.

"Rich Mcc" wrote:


you could have a 13th sheet which = totals this would be the same layout as
your other sheets but with only the colums which you want showing \ included

lets say, fred flistone is in cell a5.. in b5 just use a simple add
formula.. there are other options ideas , but this is a simple one,, and not
as daunting as it may sound, because you would only have to insert the
formula into the one cell on page 13,,

tell it to add the other 12 corrosponding cells together,,,
=sum(Sheet2!B5,Sheet3!B5,Sheet4!B5,Sheet5!B5) ect then one it is adding all
12 pages copy and paste the formula down col ),, this of course assumes that
the same driver is in the same row on every page


"Joe H" wrote:

Thanks for your reply. I will try to answer your questions:

The names are in text and the violations are in numbers. My spreadsheet is
set up with headers listing the various violations and has the Drivers Name
column . There are more things in this spreadsheet, but the only data that I
want consists of 5 columns of numbers plus the names.

I hope to end up with a monthly view of who is getting the violations and
what type of violation they are.

"Rich Mcc" wrote:

yes their are a few and varied ways of doing this. but it really depends on
how your data is presented on the "months pages" and what you want to see on
the final report, are the 5 colums of data numbers of violations or text !!!
it really does depend on the current layout and what you hope to end up with

Rich


"Joe H" wrote:

I have a large excel workbook with 12 worksheets for the months. In these
worksheets are up to 150 names with log book violations listed (we are a
trucking company). there are actually 5 colums of information for each
driver. I would like to consolidate this information at years end to see who
the main violators are. Is there any way to consolidate this data across
multiple worksheets into one easy to read worksheet?