• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 201
  • Last Modified:

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
0
Patrick O'Dea
Asked:
Patrick O'Dea
  • 2
2 Solutions
 
Patrick O'DeaAuthor Commented:
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!)
0
 
Saqib Husain, SyedEngineerCommented:
Try this file using a macro to identify the selected ID and formulas to display the data.
ManAccountsTemplateEE.xlsm
0
 
Cornelia YoderArtistCommented:
Here is an example:

=INDIRECT("'"&$A9&"'!$A$5")

will pull the value in cell A5 on the sheet named whatever is in this sheet's A9.

Perhaps you can work from this to fit it to your needs.

As for the cursor location, I have never done that, but here is an Excel Help reference page that explains how to do it.

http://www.mrexcel.com/archive/VBA/29549.html
0
 
Patrick O'DeaAuthor Commented:
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!),
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now