Can I use a formula to copy info while adding a whole 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
"cdcam" wrote:
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 ro
|