combining worksheet data

  • Thread starter Thread starter StevO
  • Start date Start date
S

StevO

Is there a way to combine data from 3 or 4 worksheets that
have a common denominator (part number) in the first
column all into ONE row? Each column will have mutually
exclusive info so it will require its own column that will
not combine any info from any other worksheet.

It will look something like this

Worksheet 1

Part | July CSM | Aug CSM | Sep CSM |
1356 | 2 | 5 | 7 |

Worksheet 2

Part | July DSM | Aug DSM | Sep DSM |
1356 | 8 | 9 | 12 |

Worksheet 3

Part | July Tot | Aug Tot | Sep Tot |
1356 | 10 | 14 | 19 |

Worksheet 4 - Combined Total

Part | July CSM | July DSM | July Tot | Aug CSM | Aug DSM
1356 | 2 | 8 | 10 | 5 | 9

Thanks for any help. This is a huge worksheet and I don't
want to go thru and cut/paste thousands of blank cells
just to get all of the info onto one combined row... if I
can help it. Yikes!
Steve
 
StevO
Go to the sheet where u want the result
Data-Consolidate.
Function=sum
reference- highlight data in sheet1 along with headers
then click add again press reference do the same for rest
of the sheet.
Check - top row and left column.
HTH
 
Back
Top