Link to home
Start Free TrialLog in
Avatar of Patrick O'Dea
Patrick O'DeaFlag for Ireland

asked on

Displaying fields in one sheet based on value held in another

Hi,

See attached.
See also my video link which should make things clearer.
It's less than 90 seconds.

http://screencast.com/t/d5Fq40az

I have 3 sheets;
Sheet1 - Detail for rest of workbook

Sheet2 - Summary of Sheet1

Sheet3 - This is my problem one!  It should display a "drilldown" of the active SubCatID chosen in sheet2.  (i.e. it will depend on where the customer places the cursor in sheet 2).
ManAccountsTemplateEE.xlsx
Avatar of Patrick O'Dea
Patrick O'Dea
Flag of Ireland image

ASKER

I am the original poster.

If the question is not clear then please advise and I will clarify.

(The double points available for this question!)
ASKER CERTIFIED SOLUTION
Avatar of Saqib Husain
Saqib Husain
Flag of Pakistan image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thanks folks for the response.
Saqib's answer seems very close to what I require.

(I just need to ensure that I understand exactly how it works!),