Auto copy info from a cell to another worksheet

[jopla]

I need to do the following:

I am entering info in one worksheet and want that info to
automacially be transferred to another worksheet. If I
delete the info in the 1st, I also want it deleted from
the 2nd worksheet. Also, is I add new info I wqant that
transferred to the second worksheet as well.

The second worksheet is sorted, although I don't that
would make any difference.

 

[Biff]

Hi jopla,

If for example you want sheet1 A1 to be
automatically 'copied' to sheet2 A1, enter this formula in
sheet2 A1:

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

When you delete the contents of sheet1 A1, sheet2 A1 will
be blank but the formula will still be in effect. Is this
what you're looking for?

Biff

 

[jopla]

Biff,

Thanks for the reply.

I have numbers and text (item description) as they appear
on a diagram on sheets A1, A2, and A3 . I would like that
info to be autmatically pasted, or written, to sheet A4,
where I can then sort sheet A4 alphabetically.

Does that make sense?

 

[Biff]

Hi jopla,

The question of 'automatically copying' data from one
sheet to another is posted here quite often. To accomplish
this, there are only two options. Use a formula such as
the example I offered or create a macro. 99.9% of the
time, the formula is the best and easiest option and is
truly automatic. From your description, it sounds like the
formula is the way to go. Sorting is not a problem because
the formula in the cell stays with the cell when sorted.
The formula I offered has generic references. You would
need to adjust them to meet your needs.

Biff