auto copy cell info from worksheet to ws

L

littlehelp

Is it possible in a workbook to enter data into one cell of a workshee
and the info would automatically be copied onto worksheet 2 an
worksheet 3 within the workbook
 
M

mudraker

littlehelp

You can do it as a formula by entering a formula in sheet2 cell a1

=Sheet1!A1

if formulas is not what you are after then you would need a chang
event macro.

if you need a macro you would need to specfy some details as
from what sheet name
to what sheet names

from what row/ column
to what row /colum
 
N

n8rboy1

You Can Right Click On The Sheets And Select All...then What You Do T
One Is Done To All....just Remember Ungroup Them When Your Done.... :
 
Top