ExcelBanter - Copy data to a specific row

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - Copy data to a specific row (https://www.excelbanter.com/new-users-excel/269616-copy-data-specific-row.html)

smith82

Copy data to a specific row

Hi,

I'm trying to copy data from "previous" sheet to "Invoice sheet with reference to the cell value in O6.

With the code I'm having now the data gets saved by one row after the another.

How may I achieve in saving data to the same row?

Any suggestion on this would be kindly appreciated.

Best Regards
Smith82

All times are GMT +1. The time now is 06:22 PM.