#### RattlingCarp3048

##### Board Regular

- Joined
- Jan 12, 2022

- Messages
- 164

- Office Version
- 365

- Platform
- Windows

The formulas in R2-X2 are being copied down to the last row of data. Then the user edits columns v-x let's say row1789. Then we update the sheet adding more data spanning down to row3458. When using the macro to copy down the formulas in columns r-x to row 3458 it is removing the user edits in row 1789.

What I need it to do is when additional data is added to columns A-Q, look up column R to the last row with formulas and copy those formulas down to the last row. Here is the initial codes:

Lastrow = cells(rows.count, "a").end(xlup).row

Range(r2:x" & lastrow).formula = range("r2:x2").formula