| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sorting and Filter in Multiple Sheets using Hyperlinks
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Want to update hyperlinks through multiple sheets but can't | Excel Worksheet Functions | |||
| Updating hyperlinks on multiple sheets | New Users to Excel | |||
| Filter Across Multiple Sheets | Excel Worksheet Functions | |||
| FILTER ONE MULTIPLE SHEETS | Excel Worksheet Functions | |||
| PLEASE HELP!sorting data using auto filter & paste the results onto seperate sheets? | Excel Programming | |||
Threaded Mode
