Duplicating/Mirror Data into another worksheet within same workboo

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

TJ - 06 May 2008 07:52 GMT

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

Reply to this Message

Pete_UK - 06 May 2008 09:39 GMT

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

> Hi,
> I am trying Duplicate Data into another worksheet within same workbook?
[quoted text clipped - 9 lines]
> Thanks
> TJ

Reply to this Message