View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
cdcam cdcam is offline
external usenet poster
 
Posts: 13
Default Can I use a formula to copy info while adding a whole new row?

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?