Duplicating/Mirror Data into another worksheet within same workboo

[TJ]

Hi,
I am trying Duplicate Data into another worksheet within same workbook?

Example: worksheet 1 and worksheet 2 (both within the same excel file)

Q// When I enter data from worksheet 1, I want it to auto mirror exactly
into worksheet 2.

I do not know how to do this or if it can be done? Please help and thank you
in advance.

Thanks
TJ

 

[Pete_UK]

In Sheet2 put this formula in A1:

=IF(Sheet1!A1="","",Sheet1!A1)

Copy this across and down for as many cells as you need.

Now if you put anything into Sheet1 it will be reflected exactly in
Sheet2.

Hope this helps.

Pete