Macro to transfer rest of data to next column on Purchase Order Form?

Need a Macro to transfer the rest of the inventory data to the next column (O) when the first column (F) is filled up on the Purchase Order Form. Also, need it to end all transfers once column (O) is filled up on the Purchase Order Form so that it doesn't continuee off the form page. Thanks!

A few changes here and there to the sheet....

The DATE field at the top used a formula that would change everytime the sheet updated. In my opinion, that's bad. The DATE field should only update when you want it to. So moved your formula over to AA1, then put a Data Validation onto J2 that used AA1 as a source, so you can click on in it and select the current time stamp anytime you want. In the future, if you reopen a saved sheet, that date would not change unless you updated with the drop down again.

I moved the TOTAL out of the form to below it so the macro wouldn't need two completely different end points, too. The macro will warn you anytime the form is filled.