would like to create a summary grid based on multiple rows of data
below

I want the summary grid to update automatically - I will then use
SUMIF to total


the data looks like this:


Col A Col B
Rob 1
Steve 1
Rob 1
Rob 1
Jared 2
Steve 5


is there any way I can dynamically create the summary grid in the
event of adding a new 'name' to the data


i.e.


Col A Col B
Rob 1
Steve 1
Rob 1
Rob 1
Jared 2
Steve 5
Jesse 1


any help appreciated


thanks
Rob


--
gwatcheater
------------------------------------------------------------------------
gwatcheater's Profile: http://www.thecodecage.com/forumz/member.php?userid=235
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=158817

Microsoft Office Help