Hi

does data / filter / autofilter give you what you need?
if not, how is your data structured?

Cheers
JulieD

"nbeaird_51" wrote in message
...
I am looking for a way to pull data (ie a specific state's financials) from
a
huge report that I have. Need a drop tab or something so when I click on
State abbrevation it pulls only that states financials from the bigger
report? How do I do this???