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!