Okay, I finally figured it out using your help and one more step. I did it
sheet by sheet instead of holding down ctrl - never could make that work.
Then the formula to keep the text is: =T('name of the worksheet'!D2:K2)
That worked. Thank you for all of your fast responses!

"Barbara" wrote:

I mean cell (not box - sorry!).

"Shane Devenshire" wrote:

Hi,

When you say "put in a certain box" what do you mean by box? Is this a cell
in the spreadsheet or an input box on a user form in VBA, or do you have a
Control Toolbox "text box" in your spreadsheet, or do you have a Form "Label"
in your spreadsheet?

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Barbara" wrote:

I have a workbook with multiple worksheets. I want to enter a formula in
certain cells that will automatically put whatever text I put in a certain
box into all the worksheets. For instance, if I type in the Agency Name, I
want it to go into that cell in each worksheet. Can anyone tell me how to do
that?

Thanks