Duplicating/Mirror Data into another worksheet within same workboo

T

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
 
P

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
 
Top