how to copy by macros?

[sawsan.sh]

Hello

Please could you help me :
I want to design a worksheet consists of 3 sheets, when I write a column of numbers in sheet1 it's automatically writed in sheet3;
the same way in sheet2 and sheet3.
I think it could be done by macros, but how exactly I don't know, could you help me?

Thanls alot.

[mudraker]

It can be done using a Worksheet Cahnge Event macro

You need to specify more details like what rows, columns or range of cells on sheet1 or to be monitered for entries/changes

Where are the copied info to be placed in the other sheets

What are the sheet names

[broro183]

Is this just for the initial setup of the spreadsheet?
If so, you can group all 3 sheets by holding down the control key as you select the sheets with the mouse (the colour of the sheet tabs will all look as if they are active). When the sheets are grouped, any typing you write in a cell on the active sheet will be duplicated in exactly the same cells on the other two sheets.

Or could changes (new data) be written in on an ongoing basis?
If so, more details are needed as Mudraker has requested (perhaps a sample workbook?).
However, what is the reason for duplicating data on all 3 sheets?
Someone may be able to suggest a better workbook design which removes the need for duplication. For example the use of a flexible Pivot Table that can present summarised data in various formats on a single sheet.

Rob