Can I use a formula to copy info while adding a whole new row?

[cdcam]

When new info is added into worksheet one it adds the new name into worksheet
2 but it only adds it in the one column and slides everything down so the
info in column b,c,d,etc. are no longer accurate. Is there a formula that
will copy the name entered into worksheet 1 to worksheet 2 but will add an
entire new row?

 

[Shane Devenshire]

Hi,

Formulas can be set up so that when new data is added they are ready. For
example suppose on sheet2 you already have the formula =Sheet1!A1 and all of
the rest of the formulas for row 1. Change these to read

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

copy this formula as far down and to the right as you need.

If this helps, please click the Yes button

Cheers,
Shane Devenshire