Search in multiple WorkSheets

Giganews Newsgroups
Subject: Search in multiple WorkSheets
Posted by:  Benoit (anonymo…
Date: Fri, 17 Oct 2003


Here is my situation:

Everyday I have to create a new repport and I use a new
worksheet for evey new day (all in the same document) with
informations on account numbers.

I would like to create a macro that will, for every new
worksheet created, check all the account numbers (one at a
time) and then go check all the other worksheet to see if
there is a match!!!

Can anyone help me out???