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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Require formula to search across multiple worksheets 2
Counting multiple memberships 1
How to insert new worksheet based on # of rows in a data sourch 2
Move rows with vlookup 3
If Function for merging multiple worksheets 2
Macro to create daily worksheets 6
How do I search multiple worksheets silmutaneously in Excel? 4
printing multiple worksheets in a workbook 1

Back
Top