Searching through several sheets in a workbook

T

Tom Atkisson

I have a workbook with 10 sheets. 5 sheet have product data in them. The
others are vlookup data, a blank formated sheet for future use, and a print
sheet i am going to use for this problem. Each sheet has its own unique
name.

Is there a way to search the 5 sheets without having to list each by name,
something like searching cells

for each cell in range

and yet not search the other 5 sheets?

For example, there are sheets named Apples, Oranges, Pears, Bananas, Grapes,
Prices, Weights, Blank, PrintList. Can i search Apples thru Grapes and not
Prices Weights Blank or PrintList?

I hope I made myself clear. Thanks in advance.
 
T

Tom Ogilvy

What stays the same? The tab order, or the sheet names.

If neither, how can the sheet be differentiated from the others. They
don't contain any formula, perhaps and the others do?
 

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

Code To Insert Blank Rows 5
Combine, sort, & then create worksheet 1
Excel Lookups 1
Creating a workbook(s) based upon a cells value <--HELP please 3
Macro to add numbers in a text string 5
Copy & Paste Non Blanks Only 4
An Easier Way 4
Copy & Paste Non Blanks Only 2

Top