Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Search Multiple Worksheets by having user type in information
Does anyone know how to create the following? I have multiple worksheets
with data for numerous calendar years. I want a user to be able to Enter a "Last name" in a cell, hit enter and have the following results displayed: 1. finds the name or names and directs them to the speciific Worksheet(s) or 2. does not find that name and leaves the cell blank. Thank you |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy information from multiple worksheets | Excel Discussion (Misc queries) | |||
Search in Multiple Worksheets | Excel Discussion (Misc queries) | |||
Search multiple worksheets | Excel Worksheet Functions | |||
How to search multiple worksheets in a workbook for information? | Excel Discussion (Misc queries) | |||
Search Multiple Worksheets | Excel Discussion (Misc queries) |