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!
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!