ConfusedNAccess
Technical User
I reposted... i didn't clarify.. EXCEL 2003 pivot table..
Does anyone know if there is a way.. or code or something that exists.. that if my report has 2 page fields.. and one of the page fields is selected, it will prompt... or update / refresh the corresponding page field on the same report????
for instance.. 2 page items are STATE, CARS, row field is MODEL and COLOR...
so if i select the state field, it will validate the next page field to the different "cars" options.. therefore if the choices were TOYOTA, HONDA.. etc.. it would updating the data to reflect the different models and colors of the car I chose???
I hope that makes sense to someone.. I NEED HELP!!!
Does anyone know if there is a way.. or code or something that exists.. that if my report has 2 page fields.. and one of the page fields is selected, it will prompt... or update / refresh the corresponding page field on the same report????
for instance.. 2 page items are STATE, CARS, row field is MODEL and COLOR...
so if i select the state field, it will validate the next page field to the different "cars" options.. therefore if the choices were TOYOTA, HONDA.. etc.. it would updating the data to reflect the different models and colors of the car I chose???
I hope that makes sense to someone.. I NEED HELP!!!