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

--
Message posted from http://www.ExcelForum.com