Excel Move Row to Sheet2 and Append

[Nu2Java]

Hello, I have some code that I found to 'cut & paste' a row of data from Sheet1 to Sheet2 which works great. The problem is, how do I get the code to append the data row by row? It will just replace the data right now. Any help is greatly appreciated.

Please Login or Register  to view this content.

[AlphaFrog]

Try something like this...

Please Login or Register  to view this content.

[amlan009]

Post your input file ,i will post a solution .

[Nu2Java]

AlphaFrog

This works like a charm... exactly what I needed. Thanks very much for your help and time.