Macro to enter data in next column if previous column is filled.

Hey guys, I've been trying to figure this out to make things more automated and streamlined at my work. Basically I've been working on this order sheet where you enter data in the current order column, and then when you click a button, it takes all of that information and adds it to the order history to the right. I've been messing around in a less sensitive workbook trying to get this to work but I'm at a point now where the macro I have will copy the appropriate data to the first column, but will not move on to the next column. It's also very important that the whole row of values is copied to the next blank column, IE if a space is left blank in the previous order, the next set cannot fill that blank space in, everything just goes to the next wholly empty column.

order history.xls

A copy of that order sheet so you can see what I'm trying to do and how to apply it. Here's the macro I've shoddily assembled here. I know it's not terrific and I'm sure somewhat redundant but I am no excel expert, hence, I come here.

Please Login or Register  to view this content.

Hopefully someone here is enlightened enough to help me out with what seems like a fairly simple issue.