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? |
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 |
All times are GMT +1. The time now is 08:03 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com