B
Box666
Overview of problem. I will end up with a workbook that will have a
large number of worksheets in it. Each worksheet will have approx 6
columns the number of rows will vary from a few hundred to a few
thousand. Each sheet is a decode document for a database.
The users need to know if there is a common field. As an example
sheet1 relates to shop locations (each shop has its own reference no.)
sheet18 relates to Sales also on this sheet the shops reference no.
Users will need to search for shop ref no.
What I think I need is some form of “search” sheet, so there will be a
box into which users will type the field they are looking for—in this
example “shop ref” . It will then return an answer of sheet1 and
sheet18plus all of the other sheets that reference shop ref, so the
user can then go to those sheets and view the records. Whilst this is
a very simple example, I believe the searches could get complex.
How is the best way to tackle this type of problem, for example do I
need to combine all of the sheets onto one in some way, so that the
search page only has to search the one sheet. (not to sure practical
this is),,,,,,,,, or is there a way that EXCEL can search each sheet
individually and then report the results accordingly.
Is anyone aware of a sample spreadsheet that might do something
similar that I might be able to adapt.
Any thought or ideas gratefully accepted
Bob
large number of worksheets in it. Each worksheet will have approx 6
columns the number of rows will vary from a few hundred to a few
thousand. Each sheet is a decode document for a database.
The users need to know if there is a common field. As an example
sheet1 relates to shop locations (each shop has its own reference no.)
sheet18 relates to Sales also on this sheet the shops reference no.
Users will need to search for shop ref no.
What I think I need is some form of “search” sheet, so there will be a
box into which users will type the field they are looking for—in this
example “shop ref” . It will then return an answer of sheet1 and
sheet18plus all of the other sheets that reference shop ref, so the
user can then go to those sheets and view the records. Whilst this is
a very simple example, I believe the searches could get complex.
How is the best way to tackle this type of problem, for example do I
need to combine all of the sheets onto one in some way, so that the
search page only has to search the one sheet. (not to sure practical
this is),,,,,,,,, or is there a way that EXCEL can search each sheet
individually and then report the results accordingly.
Is anyone aware of a sample spreadsheet that might do something
similar that I might be able to adapt.
Any thought or ideas gratefully accepted
Bob