Is is possible to search a worksheet by a "unique identifying" number, which will then show the results [a new file, i.e. "Sheet2"] as another, seperate page?
Hope this makes sense as I need to create something which will do this ASAP.
Cheers. 
URGENT: Search field in Excel XP
Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.
-
-
Are your numbers in one column (e.g a:a)
If so you can use autofilter to filter for your number and copy & paste to another sheet.Here's some tips for creating an Excel Database
CREATE AN EXCEL DATABASE
There are certain requirements necessary to enable the use of the "Data" Menu functions in Excel
The Database must be a set of columns and rows without any empty row or empty column and there must be a title row.
The Database must be separated from any other data in your Worksheet(Tab) by empty rows and columns (row "1" and column "A" of the worksheet do not have this requirement)
Column headings should be in single cells in a single row. Use "Text Wrap" in Format/Cells/Alignment to write more than one line of text in one cell.
By using bold and underlining for the Column Titles, Excel will better recognise your Database.
To make sure that your Excel database is recognized as such by Excel, click anywhere in it and choose Edit/Go to/Specials/Current Region.Excel will now recognise your Data area as a Database
You can now use the inbuilt Database functions from the Data Menu such as Form,AutoFilter, Advanced Filter, Subtotals etc
This can be done by VBA as well if you want
-
Have alook at this
-
-
This is a different query to your first request. Maybe a PivotTable might be what you are looking for
Have you got an example of your data that you can attach? -
Example updated to show results in PivotTable
-
OK, I'll try and give you a better insight as to what I'm trying to achieve
There's a file we have which has a person's name, employee number and their rate of pay, etc
They want to be able to search by number, which will then display the appropriate, corrosponding xls file with the person's details on ...
-
If you have your sheetrs in one workbook this example might work
You can also insert hyperlinks from an Index sheet to other workbooks
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!