I was hoping fo something more simple. Multiple people will be using this
work book. I was hoping to find something were someone could just go to one
page and enter say number "2136" and it would pull up information on that
item, for instance the location, description ect.

I'm basing what I'm trying do on a vlookup program I did looking locations
by the location number.

Thank You

"JulieD" wrote:

Hi

you can use code along the following lines

Sub FindAcrossSheets()
Dim wks As Worksheet
Dim sname As String

i = 20
For Each wks In Worksheets
If UCase(wks.Name) = "SHEET" & i And i < 28 Then
With wks.Cells
Set c = .Find("AAAAA")
If Not c Is Nothing Then
Sheets("Sheet1").Range("A1").Value = c.Worksheet.Name
Exit Sub
End If
End With
i = i + 1
End If
Next wks

End Sub


---
this code looks for the text AAAAA in any worksheet (with sheet names of
Sheet20 to Sheet 27) and if found puts the sheet name into Sheet1 cell A1

to use this code, right mouse click on a sheet tab, choose view code, in the
vbe window choose insert / module - copy & paste the code in there. Change
AAAAA to what you're looking for

switch back to the workbook ALT & F11 and choose tools / macro / macros -
find "FindAcrossSheets" and press RUN.

Hope this helps
Cheers
JulieD


"jtinne" wrote in message
...
Okay I understand vlookup will not work and based on all the responses
I've
have recieved, I need to use VBE. I have never used that before and don't
even know where to begin. If anymore can offer some tips, please do.

Thank You.

"jtinne" wrote:

I need a couple formulas to search a range of sheets on my workbook.

The first one needs to be able to seach through a range of sheets (exp.
sheet 20 to sheet 27) and find my value then I want it to display the
name of
the sheet it is on.

Second is to seach a range of sheets then display a value of a specific
cell
on that sheet it is found on.

Thank you for the help!