Help with some kind of search

[james502]

Hi all,

I really need help! I have contacts in Excel 1997 simply with names and dates in two sperate columns. They are in different work sheets depending on where they are based. What I need to do is somehow create a search (the whole workbook) based on either a name or a date which will display the whole row (name and date) also it would be helpful if it indicated which speadsheet it was from, but I guess I could colour code it if that's not possible.

I know about Ctrl F, which is helpful but it doesn't give me all the details in the row when it does find something. Is there a simple funtion I could use?

Any help would be great.

Thanks!

 

[sthrncaliguy]

You will probably need to use a Macro Loop to accomplish this...

Something like this..

Sub FindData()
Dim ws as Worksheet, Dim rRow as Integer
 
For each ws in Worksheets
rRow = Application.WorksheetFunction.Find("Criteria", ws.cells).row
'Process Results
Next
End Sub

if you provide more details I can help you with the exact code needed to accomplish the task.

 

[james502]

Basically it's just peoples names I have booked in one row and in the next row I have the dates they are booked. I have seperate worksheets for each place I have bookings for about 10 worksheets. Some names are booked up on multiple places (worksheets) they are booked at. There is a notes row also, I'm not to fussed if that ends up in the search or not.

Column A is dates, B is surname, C is notes

 

[james502]

Doh, I mean a notes column, not a notes row.

Do you have any idea how I can do this, talk to me like I'm retarded because I'm not to good with Excel at all!

Thanks!

 

[sthrncaliguy]

Is there anyway you can post a sample workbook?

 

[james502]

No worries.

How do I attach it? E-mail?