I'm afraid it depends on how you have set out the structure of your
invoice, would you want the information to appear in a single row on
worksheet 2?

feel free to join the forum in the signature below where you can attach
a workbook to your post, if you do join, take note of this link:
http://tinyurl.com/93xnpk and post in that thread with your workbook,
that way all the people who have been follwing this thread here and wish
to help will still be able to!

ComputerMech;167242 Wrote:
Ok here is what I need help with.
In sheet 1 I have a Invoice I would like to create a database of my
customers
So when I have wrote out the Invoice I would like to hit a command
button
that would send it to WS 2 next empty row. What would be the best way
to do
this.


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=46344