Help with some kind of search

james502

New Member
Joined
Aug 18, 2010
Messages
4
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!
 

Some videos you may like

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.

sthrncaliguy

Board Regular
Joined
Jul 28, 2009
Messages
213
You will probably need to use a Macro Loop to accomplish this...

Something like this..

Code:
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

New Member
Joined
Aug 18, 2010
Messages
4
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

New Member
Joined
Aug 18, 2010
Messages
4
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!
 

Watch MrExcel Video

Forum statistics

Threads
1,122,576
Messages
5,596,973
Members
414,115
Latest member
SFUser

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top