I need the command button on worksheet SLA Order to copy only the cells with data in them from the green cells above the button and paste them into worksheet SLA
See attached sample worksheet
The current code on the command button is below.
I need it to only look at the range in green and ignore the cells with data below
Further explination of Sheet if needed:Please Login or Register to view this content.
Goto Home and put type test into cell B4 and and hit New Order Command button. This has just created a new worksheet called 'test SLA Order'
(SLA Order is my template sheet)
Goto test SLA ORDER and fill in the first couple of rows from the drop down boxes and enter a quantity in the next cell.
So what I need is for the command button on this worksheet to copy only the cells with anything in them from the green cells above and paste them into the
worksheet Totals.
When a new order is created there may be a different number of cells filled in on the newly created worksheet %%% SLA Order and again I need the command button on this worksheet to copy only the cells with anything in them from the green cells above and paste them into the
worksheet Totals directly below the previously pasted cells.
Bookmarks