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

  • Thread starter Thread starter cdcam
  • Start date Start date
C

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