Recent content by franku

Sample of data type: YEAR Type Description PartNo Price 2004 a123 Gadget123 19.21 2004 a125 Gizmo 125 57.53 2004 b321 Thingy 532 128.96 2005 a123 100123 19.98 2005 a124 100124 87.22 2005 a125...

patrik, tried your suggestion. I have two lists, Both have type codes. One has 2004 prices and descriptions but no ident numbers. The other has 2005 prices and ident numbers but no descriptions. When I do as you suggest, I end with list of type codes which has a line for 2004 price, description...

I want to merge two Excel sheets. One has 2004 prices for 6000 products (identified by type code) with descriptions. The other has 2005 prices with type code but without descriptions and with part codes for 9000 products. Some parts in 2004 are not in 2005 and vice versa. I want to end up with...

Can anyone advise on reliable inexpensive software for collect/send and internal distribution of e-mail. Have been using package called c-mail but supplier is withdrawing support.

Thanks Ken. That worked a treat. I had to halve the spreadsheet but that's not a problem. Problem is what do I do with the other fields associated with the part number e.g. description,type code so they stay with the part numbers in the new table. I belong to the old 1-2-3 clan so this stuff...

Thanks guys. But before I go running in different directions, I should point out that there are part numbers in the 2003 list that are not in the 2004 one and vice versa. So its not just sorting. So should I try VLOOKUP, MS QUERY or PIVOT?????

Is there a way to compare and merge info from two spreadsheets? I have a 2003 parts list with prices and descriptions. I now have a 2004 parts list with additional parts and new prices. I need to insert the new prices opposite the correct part number on the old spreadsheet. Any Ideas?