hello. this may be difficult to understand but i'll try to make it simple.i am using ExcelXp. i have made a small place for a person to enter their details. it is entered down the page with me leaving a cell row between data. ithen want to copy each bit of data and paste or 'record' it onto another sheet in the same book, but when using a macro the data always ends up in the same cells, so the data is overwritten. i know it may have something to do with relative reference but cant get it to work. the function must ideally be controlled by a macro.i have screenshots avaliable upon request. thanks

It would help if you post your code. The copy/paste action should look something like the following: Sheets("All").Rows(ActiveCell.Row).EntireRow.Copy _ Destination:=Sheets("Sheet3").Range("a65536").End(xlUp).Offset(1, 0)