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?