Hey guys,
I am a newbie..and hope you can help. Please bare in mind that I am crap at trying to explain myself.
The simplest way I can say it is...imagine you have a database, it has x amounts of sheets to it.
Each sheet deals with a different area, ie. sheet 1 deals with england, sheet 2 deals with spain sheet 3 with greece etc etc...
Each sheet has detailed information about the cites in that area and also numerous banks (Abbey, Natwest etc) in those cites. How do I collate all the 'Abbey' banks to one sheet. So I want to have all the abbey banks on one sheet, I want to search over all the different areas (ie all the different sheets in the workbook) So I know how many Abbey's there are in the World.
This is merely for trying to explain my what I need to do. I hope you understand and that you can help!!!
I know you could just do a find search for 'abbey' over the workbook as opposed to on the sheet, but I need a list in excel..and searching merely highlights what you are looking for.
Anything that can help is welcome, I thank you all in advance, you very nice people
Cheers
QT E
I am a newbie..and hope you can help. Please bare in mind that I am crap at trying to explain myself.
The simplest way I can say it is...imagine you have a database, it has x amounts of sheets to it.
Each sheet deals with a different area, ie. sheet 1 deals with england, sheet 2 deals with spain sheet 3 with greece etc etc...
Each sheet has detailed information about the cites in that area and also numerous banks (Abbey, Natwest etc) in those cites. How do I collate all the 'Abbey' banks to one sheet. So I want to have all the abbey banks on one sheet, I want to search over all the different areas (ie all the different sheets in the workbook) So I know how many Abbey's there are in the World.
This is merely for trying to explain my what I need to do. I hope you understand and that you can help!!!
I know you could just do a find search for 'abbey' over the workbook as opposed to on the sheet, but I need a list in excel..and searching merely highlights what you are looking for.
Anything that can help is welcome, I thank you all in advance, you very nice people
Cheers
QT E