building a worksheet row by row

[Guest]

I hope somebody can assist.
My worksheet calculates rows of data, which I wish to slide into another
worksheet and secure; then change the original data, slide those results
under the first. Keep repeating.
Is there a way to do this without manually pasting values each time?

David

 

[Gord Dibben]

Dave

"Sliding" rows from one sheet to another would involve the use of VBA.

See Ron de Bruin's site for moving/copying rows to next available empty rows.

http://www.rondebruin.nl/copy1.htm

Gord Dibben Excel MVP

 

[Dave Peterson]

Maybe you could record a macro when you do it once.

Post back if you have trouble generalizing it--with a few more details.