Copy range to next empty row in a table on another sheet with VBA

[vicguz33]

Hello everyone,

Firstly, I would like to thank everyone participating in this forum for their great input, I have really learned a lot from you all!


I am currently looking to set up an order sheet that saves all past orders to a table, which can be seen in my attached workbook.


My goal is for all cells with data in range "OrderRange" (A10:G36) on the "Order Form" sheet to be copied to the next empty row on the "PastOrders" table in "Order History" sheet. I would like this to be triggered everytime the user clicks the black "Place Order" button up top.

So far, I have been succesful in being able to copy "OrderRange" to "PastOrders", but I still have two main issues:

1. I would like for empty/blank cell rows to be skipped so that there aren't any empty row in the "PastOrders" table.

2. As of right now, clicking the "Place Order" button only causes for the data in the "Past Orders" table to be overwritten, I would like for the data to be copied underneath on the next open row with each click.


I would really appreciate it, if someone could help shed some light on where my VBA code is falling short.


I thank you in advance!!!

[p24leclerc]

try this modified macro:

Please Login or Register  to view this content.

In the "Order History", be sure to have something in cell A2 for your first run because it may create an empty row.

[vicguz33]

Hello p24leclerc,

I apologize for not being able to write you sooner. I decided to take the later/better part of last month off for Holiday =)

I was however able to get around to plugging your updated macro, and everything worked exactly how I had hoped!

Thank you very much for your help, I greatly appreciate it!