2 of 2 people found this helpful
It sounds like you want to set this up with a parameter instead. I have attached a workbook which uses a parameter combined with a calculated field. More information on parameters can be found here: Create Parameters
Does this work for you?
Yes Chris this is what i was looking for.
Thanks a lot.