Merge data with inventory serial number

**tedgraniou** · 06-05-2012, 09:56 AM

Hi all,

I've bought a EAN scanner and connected it to Excel2003. The scanner inserts the new data in a new line everytime no matter if its duplicates.
For example;

LAN cable 5 meter
LAN cable 5 meter
LAN cable 5 meter
LAN cable 5 meter
LAN cable 5 meter
LAN cable 1 meter
LAN cable 1 meter
Fiber Cable 3 meter
Fiber Cable 3 meter
Fiber Cable 3 meter

Now, i would like Excel to automatically merge all LAN cable 5 meter into one field with a total number of for example LAN cable 5 meter.

I sincerely hope anyone gets what i'm talking about and can help me out.

Kind regards/
Ted

**Kelshaer** · 06-05-2012, 10:25 AM

Try this assuming that the items name will be in column A and the count will be placed in column B

Please Login or Register  to view this content.

**tedgraniou** · 06-07-2012, 04:16 AM

Thank You Khaled!

Have a nice day!

Kind regards/
Ted

**Marcol** · 06-07-2012, 04:38 AM

Do you realy need VBa for this?

Try this formula approach, no need to call macros the sheet will automatically update as data is added.
Best to use native formula whenever you can.

1/. Create a Dynamic Named Range "Raw_Data"
Refers to:=

Please Login or Register  to view this content.

2/. In say C2

Please Login or Register  to view this content.

and in D2

Please Login or Register  to view this content.

Drag/Fill both Down as far as you need.

**tedgraniou** · 06-08-2012, 03:37 AM

Thank you most kindly Marcol, i will try this out too.

Have a nice day!

//Ted

Merge data with inventory serial number

LinkBack

Thread Tools

Rate This Thread

Display

Merge data with inventory serial number

Re: Merge data with inventory serial number

Re: Merge data with inventory serial number

Re: Merge data with inventory serial number

Re: Merge data with inventory serial number

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions