Hyperlink and Filter Data in Multiple Sheets

S

Sheikh Saadi

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,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sorting and Filter in Multiple Sheets using Hyperlinks 2
Macro to copy data X number of times into a column 0
Matching Rows with Multiple Columns in Two Worksheets 0
Trace common material in 2 sheets 4
Problem with formula in grouped sheets 2
how to have a form that generate invoice no. 2
List items on 1 table NOT in another 3
Select item from one table not in another 1

Top