| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hyperlink and Filter Data in Multiple Sheets
Hi,
I have an Excel Workbook containing multiple sheets. Sheet1 contains my Customers data consisting CustID, CustName, CustAdd, CustPhone etc. Sheet2 contains Orders placed by customers consisting CustID, OrderID, OrderDate etc. I have CustID field common in both the sheets. Now I want that CustID in Sheet1 gets hyperlinked with CustID field in Sheet2. Meaning, when I click on CUS0005 in Sheet1, it will jumps to Sheet2 and filter out the data only for CUS0005 in Sheet2. I think this could be done. Plz tell me if I am making any sense. Thanks, -- Sheikh Saadi |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Filter Across Multiple Sheets | Excel Worksheet Functions | |||
| Macro to Filter Information in Multiple sheets and Make graph | Excel Worksheet Functions | |||
| Excel filter over multiple sheets | Excel Worksheet Functions | |||
| Inserting a hyperlink with "Data Filter" on, in Excel | Excel Discussion (Misc queries) | |||
| FILTER ONE MULTIPLE SHEETS | Excel Worksheet Functions | |||
Linear Mode
