Multiple worksheet

W

Wellington

When adding new data to the main worksheet I am wanting it to go onto other
specific worksheets. However, the row number of the main database is
considerably higher, therefore when the data is copied to the other chosen
worksheets they do not carry on from the list of data present on that work
sheet but go to the row number that the data was entered on.

I am wanting the new data to continue on as a list.

Hope this makes sense
 
A

Anna

Not sure your questions. I guess below is the an example of VBA that you
could copy the cell that your point stay in sheet 1 to sheet 2 cell a(x).
a(x) is the next 'blank cell' count from A1.

Sub Macro()
Selection.Copy 'select the area your want to copy
Sheets("Sheet2").Select
Application.Goto Reference:="R5000C1"
Selection.End(xlUp).Select
ActiveCell.Offset(1, 0).Select
ActiveSheet.Paste
End Sub
 
Top