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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Help to copy information from one row at a time to another sheet 1
VBA - retrieve data on last create named range from previous inserted named range 0
Formula from consecutive rows to alternate rows? 2
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
copy/paste row with one formula 6
Copy within a subtotal 1
Search, Copy & Paste Formula 1

Back
Top