Patrick O'Dea
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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!),
Saqib's answer seems very close to what I require.
(I just need to ensure that I understand exactly how it works!),
ASKER
If the question is not clear then please advise and I will clarify.
(The double points available for this question!)