Search in multiple WorkSheets

  • Thread starter Thread starter Benoit
  • Start date Start date
B

Benoit

Hello,

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???

Thanks!!!
 
You might try the LOOKUP function.
You can read up on it in HELP and see if this is what you
are after.
What is it you want to accomplish by finding a matching
account number in another sheet?
 
Back
Top