How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask Richard Your Own Question
Richard, Software Specialist
Category: Microsoft Office
Satisfied Customers: 36526
Experience:  Over 15 year experience resolving Microsoft Office Issues
Type Your Microsoft Office Question Here...
Richard is online now
A new question is answered every 9 seconds

Need someone to walk me through setting up filters in Excel

Customer Question

Need someone to walk me through setting up filters in Excel for the following:
Sheet 1 has a primary key with summary attributes for parties
Sheet 2 has the party key and 1 to many addresses for each party
Sheet 3 has the party key and 0 to many communication methods (phone,fax,email) for each party
When user clicks on any row in sheet 1 and then goes to sheet 2 or 3, I want results limited to the rows with same party key as that selected in sheet 1.
In the past, company I work for did that in VBA but I don't have that set up on laptop so hoping there is a Excel only method for doing that.
Submitted: 11 months ago.
Category: Microsoft Office
Expert:  The-PC-Guy replied 11 months ago.

you certainly can filter by a value manually.

but to have something change automatically when someone clicks something will require VBA, no way around this fact.

Customer: replied 11 months ago.

ok. I'll have to pass on that. Thanks.

Expert:  Richard replied 11 months ago.

Hi there and welcome

You will always have VBA set up as it is within Excel, so you can use a VBA procedure within your sheet, this will work for you Shannon.

Related Microsoft Office Questions