Merging duplicate records in a sheet

[nd2006]

Hi all,

I have a stock control spreadsheet, which I am using for a stock take.

I am importing data from a handheld scanner into excel and using lookups to cross reference, which works great apart from one thing, when the same thing has been scanned more than once, it adds duplicate records. IE:

Code Desc Q.
102 Pen 1
301 Pencil 3
301 Pencil 4
543 Ruler 2

So what im looking for is some form of macro or code to go through the entire book and merge all the duplicates, adding the stock numbers so i would end up with this:

Code Desc Q.
102 Pen 1
301 Pencil 7
543 Ruler 2

Is this possible in excel, or would it be easier to run something on the original output file, which is a comma and space seperated text file.

Many thanks, any help much appreciated.
Nick

[rylo]

Nick

Try this. Puts the output in the same sheet, starting in column E.

Please Login or Register  to view this content.

HTH

rylo