How do I set up a form with a dropdown linked to another sheet?
 

ok, here is what I want to do: I have about 500 records in a sheet we will
cal 'raw data'. I want to have a main sheet that pulls data in from the 'raw
data' sheet. I wanto to be able to click on a dropdown, and select one
record at a time and have it populate a number of fields as well as a radar
chart within the main sheet. How do I do this? I thought I knew Excel
pretty good but I have no idea how to even start...Should I be doing this in
Access instead? Reason I was thinking Excel was because I could then send out
a copy of this with no problem of compatibility. Also, I would also like to
then print out the population of these records as they are formatted on the
main sheet. So 500 one-page sheets with all pertinent info and charts. I
think I may be in over my head here... Any suggestions?

How do I set up a form with a dropdown linked to another sheet?
 

You could set up your fields using an INDEX/MATCH formula, using the
dropdown cell (I assume DataValidation) as the value to be searched.
Then when you select from the dropdown, the INDEX/MATCH returns the
values from the corresponding row as the value you selected.

Does that make sense?

What is the radar chart for? Where does the data come from? How does
it relate to the previous problem of wanting to draw data from the
data sheet?

--JP

On Oct 13, 1:37*pm, Roy Bernal
wrote:
ok, here is what I want to do: *I have about 500 records in a sheet we will
cal 'raw data'. *I want to have a main sheet that pulls data in from the 'raw
data' sheet. *I wanto to be able to click on a dropdown, and select one
record at a time and have it populate a number of fields as well as a radar
chart within the main sheet. *How do I do this? *I thought I knew Excel
pretty good but I have no idea how to even start...Should I be doing this in
Access instead? Reason I was thinking Excel was because I could then send out
a copy of this with no problem of compatibility. *Also, I would also like to
then print out the population of these records as they are formatted on the
main sheet. So 500 one-page sheets with all pertinent info and charts. *I
think I may be in over my head here... Any suggestions?

How do I set up a form with a dropdown linked to another sheet
 

Well it turns out i won't need the radar chart after all. Howver, thevalues
used to populate the chart are included in the 'raw dta' sheet as well...
What I was trying to do was to use some of the values to populate the chart.
So basically everyhting I would need for the chart as well as the one page
report would be found within the raw data sheet. This raw data sheet has like
100 columns in it. so it is pretty extensive.

"JP" wrote:

You could set up your fields using an INDEX/MATCH formula, using the
dropdown cell (I assume DataValidation) as the value to be searched.
Then when you select from the dropdown, the INDEX/MATCH returns the
values from the corresponding row as the value you selected.

Does that make sense?

What is the radar chart for? Where does the data come from? How does
it relate to the previous problem of wanting to draw data from the
data sheet?

--JP

On Oct 13, 1:37 pm, Roy Bernal
wrote:
ok, here is what I want to do: I have about 500 records in a sheet we will
cal 'raw data'. I want to have a main sheet that pulls data in from the 'raw
data' sheet. I wanto to be able to click on a dropdown, and select one
record at a time and have it populate a number of fields as well as a radar
chart within the main sheet. How do I do this? I thought I knew Excel
pretty good but I have no idea how to even start...Should I be doing this in
Access instead? Reason I was thinking Excel was because I could then send out
a copy of this with no problem of compatibility. Also, I would also like to
then print out the population of these records as they are formatted on the
main sheet. So 500 one-page sheets with all pertinent info and charts. I
think I may be in over my head here... Any suggestions?