Spreadsheets--Adding Quantities
 

If I have two different worksheets, lets say spare mechanical parts, that
list the part number in 1 column and the quantity in stock in another column.
Is there a way to bring them together so that the quantities of any
duplicate part numbers will add up? For instance if on 1 spreadsheet I have
Part# 1234 with a quantity of 5 and on the other spreadsheet I have the same
Part # 1234 but with a quantity of 10; I want to bring those together on 1
spreadsheet so that Part # 1234 has a quantity of 15.

Spreadsheets--Adding Quantities
 

Are the part # and quanties in the same columns in the various sheets?
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"WhiteS" wrote in message
...
If I have two different worksheets, lets say spare mechanical parts, that
list the part number in 1 column and the quantity in stock in another
column.
Is there a way to bring them together so that the quantities of any
duplicate part numbers will add up? For instance if on 1 spreadsheet I
have
Part# 1234 with a quantity of 5 and on the other spreadsheet I have the
same
Part # 1234 but with a quantity of 10; I want to bring those together on 1
spreadsheet so that Part # 1234 has a quantity of 15.

Spreadsheets--Adding Quantities
 

No they are not at the moment. I could try to do that, especially if it
saves some work!

"Bernard Liengme" wrote:

Are the part # and quanties in the same columns in the various sheets?
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"WhiteS" wrote in message
...
If I have two different worksheets, lets say spare mechanical parts, that
list the part number in 1 column and the quantity in stock in another
column.
Is there a way to bring them together so that the quantities of any
duplicate part numbers will add up? For instance if on 1 spreadsheet I
have
Part# 1234 with a quantity of 5 and on the other spreadsheet I have the
same
Part # 1234 but with a quantity of 10; I want to bring those together on 1
spreadsheet so that Part # 1234 has a quantity of 15.

Spreadsheets--Adding Quantities
 

Ok, so actually what I am trying to do is match up Part#'s w/ their
descriptions in two different worksheets. Sorry for the confusion! Any way
to do this?

"Bernard Liengme" wrote:

Are the part # and quanties in the same columns in the various sheets?
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"WhiteS" wrote in message
...
If I have two different worksheets, lets say spare mechanical parts, that
list the part number in 1 column and the quantity in stock in another
column.
Is there a way to bring them together so that the quantities of any
duplicate part numbers will add up? For instance if on 1 spreadsheet I
have
Part# 1234 with a quantity of 5 and on the other spreadsheet I have the
same
Part # 1234 but with a quantity of 10; I want to bring those together on 1
spreadsheet so that Part # 1234 has a quantity of 15.

Spreadsheets--Adding Quantities
 

Have you looked at VLOOKUP and SUMIF?
Tell us how the data is set out on each sheet. Tell us what result you are
looking for.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"WhiteS" wrote in message
...
Ok, so actually what I am trying to do is match up Part#'s w/ their
descriptions in two different worksheets. Sorry for the confusion! Any
way
to do this?

"Bernard Liengme" wrote:

Are the part # and quanties in the same columns in the various sheets?
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"WhiteS" wrote in message
...
If I have two different worksheets, lets say spare mechanical parts,
that
list the part number in 1 column and the quantity in stock in another
column.
Is there a way to bring them together so that the quantities of any
duplicate part numbers will add up? For instance if on 1 spreadsheet I
have
Part# 1234 with a quantity of 5 and on the other spreadsheet I have the
same
Part # 1234 but with a quantity of 10; I want to bring those together
on 1
spreadsheet so that Part # 1234 has a quantity of 15.