Being the Excel "newbie" that I am, I'm hoping someone can shed som
light on Advanced Filters and if it can do what I HOPE it can do.

I've got a BOM generated from data from AutoCAD. The BOM contain
information such as 'room name', 'room number', '# of telephones', '
of PCs', etc...

What I would like to do is be able to create a new sheet (that's th
easy part), then extract and SUM the information based on the roo
number. For example: If I have 3 entries for room 101 where entry
has: 1 telephone & 0 PCs; Entry 2 has: 1 telephone & 2 PCs; Entry 3 ha
3 telephones and 1 PC.

I'd like to be able to combine that information to read: Room 101,
telephones & 3 PCs.

It SEEMS that the Advanced Filter can do this, but I just don't hav
NEARLY enough experience with Excel to even know where to begin.

Any help will be greatly appreciated!

Thanks in advance!

Matt

--
Message posted from http://www.ExcelForum.com