auto copy cell info from worksheet to ws

  • Thread starter Thread starter littlehelp
  • Start date Start date
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
 
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
 
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.... :
 
Back
Top