Please see attached sheet
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.
But with each new customer a new worksheet is created from SLA Order with a new name based on what is in cell B4 on worksheet Home when button on that sheet is activated.
So each new SLA Order worksheet will have a different number of cells filled in depending on customer order. The command button must copy only these cells and paste them into worksheet SLA directly below any previous cells pasted there.
Can anyone give me a hand with this
Cheers
Bookmarks