Sheet help

[ashleykay31]

Say I have mulitple sheets and in one sheet i want to type in something in a cell and then on another sheet i just want it to copy over when i type it in..do you know of anyway to do this?? Any help would be great!!

Thanks

 

[NBVC]

Two ways:

In the other sheet enter =Sheet1!A1, if A1 is what you want copied over

or

While holding the CTRL key, click on all sheets you want to make same entry to. The sheet tabs should turn white.

And start making entries.

When you click over to other tabs, you should see the same entries.

 

[Legacy 51064]

Select all of the sheets that you want and type your information into one of the sheets. The information will be copied to the other sheets.

 

[Tazguy37]

If you just want the values copied (so you don't see the formulas), that can be done as well, it's just a little more complicated.

NBVC beat me to the easy way of doing it. :wink: