Very challenging

M

madcat

I have a situation here and it goes like this

I have 2 data spreadsheet(SP). 1st SP is unapproved data and 2nd SP i
approved data.

1) How can i make the spreadsheet to copy unapproved data over t
approved data, 2nd SP and delete from 1st SP?

2) How can i add to the next line automatically if there are alread
data in 2nd SP? I.e. Ln1 to Ln10, there are data. Thus, next data woul
be Ln11
 
J

JE McGimpsey

One way:

Since you don't specify, I'll assume you want to copy the rows which are
selected:

Public Sub CopyOver()
With Selection.EntireRow
.Copy Destination:=Sheets("SP2").Range( _
"A" & Rows.Count).End(xlUp).Offset(1, 0)
.Delete
End With
End Sub
 
Top