Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy info into empty cells below info, until finds cell with new d | Excel Discussion (Misc queries) | |||
Adding Colum to a Row od info... | New Users to Excel | |||
Adding Info to Chart | Charts and Charting in Excel | |||
how do I copy info from one sheet to another via a formula? | Excel Worksheet Functions | |||
Adding info in the row at the bottom using macro? | Excel Discussion (Misc queries) |