IF Statement loop

Hi,

I have a userform with 16 rows of 5 textboxes which can be filled in. What I need is the code to do an if statement (or something similar) to check whether the first textbox in the row is filled in and if it is the data in that row is copied to the data sheet and so on. But if textbox 1 in row 3 (for example) is not filled in do not copy but check the following rows and copy where necessary.

Thank you in advance.

Question can also be found here:
http://www.mrexcel.com/forum/showthread.php?t=465815

http://www.mrexcel.com/forum/showthread.php?t=465815

If you choose to x-post please have the courtesy to provide links (per the Forum rules) - not doing so will generally lead to your posting rights being revoked.