Auto copy info from a cell to another worksheet

  • Thread starter Thread starter jopla
  • Start date Start date
J

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.
 
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
 
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?
 
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
 
Back
Top