Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 195
  • 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

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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