I don't understand your question. If you know the name of Sheet2, just put
the name in the formulas. Does the name of the sheet change?

wrote in message
oups.com...
Thanks. that worked.

I have one remaining question that I forgot to add earlier.

How would I do this if the Sheet2 is "added" a later time?

Basically, Sheet2 is created during a "filter" action. People work
from Sheet2 entering information into columns O,P,Q.
I have Sheet2's name set up as a string and placed ina cell for
reference. How can I use that to do what you are suggesting?