copying data
 

Hi,
I have a problem (again)
I need to copy a ROW of information to predetermined cells on another
worksheet in the same workbook.
Now i can do this with the first row of data by individually assigning the
data. but i also need to do this with the next row as well.
Basically i am copying data from row in a database on excel and moving it to
an invoice sheet into predetermined cells. That i can do. but i need to move
the next row of data to a new invoice sheet. how do i do that? and is there a
way of writing VBA code that will do it all for me with one "click" of a
custom made button?
I am new to VBA so please be gentle!
Thanks in advance.