Parameter Query-enter just once for use in multiple places

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an Excel spreadsheet where I have multiple places I am searching for
an amount within a range of dates. When asked what the check date is, I only
want the user to have to answer the question once, when the parameter box
pops up. Then this answer would be carried forward to the various criteria.
Right now, the box pops up seven times, where you have to put the same check
date over and over again. Anyone know how to accomplish this?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top