Hi,
I am new to VBA programming but understand a little of Perl, I am
trying to read the contents of all Excel worksheets within a workbook
and then summarise this data on a seperate worksheet, a lot of the
data in the worksheets is diplicated and I do not want this
duplication appearing on the new summarised worksheet. What I was
hoping to do was store the data in a hash table (like perl) and then
test for the existance of the key each time I added data to it or
simply just put the new key over the top as the value would be the
same as well as the key. Is there a way I can do this within VBA and
if possible give me an example..

many thanks, Mark.