Hello,

This is my first time doing this, so please forgive my lack of knowledge.

I am trying to copy information from a sheet in excel to another, so I did a
record macro and performed the operations....problem is, I need this repeated
until all the data is done.

Present Layout:
Column A ColumnB ColumnC, etc
SalesOrder 1234 5678
PONumber 6678 1111
InvoiceDate 12/22/07 12/22/47
RequiredSipDate 08/12/07 01/01/2008

And I'd like it to look like this
SalesOrder PONumber InvoiceDate RequiredSipDate
1234 6678 12/22/07 08/12/07
5678 1111 12/22/47 01/01/07

and I'd like the Macro/Program to run until there is no more info in the
sales order
row of the original layout.

Help!