Can anyone help me with this.
Please look at the workbook attached. What I need the command button on worksheet 'SLA Order' to do is the following:
Copy only rows with data in them from columns A:C and paste them into the worksheet 'Totals'
If I add more rows of data in the worksheet 'SLA Order' and hit the command button it will again copy only rows with data in them from columns A:C and paste them into the worksheet 'Totals' but it must copy it must paste them directly below the previous pasted cells
i.e. there are 2 line of data. I hit the command button and then add 3 lines of data to the 2 lines of data and hit the command button. There should now be 7 lines of data in the the Totals worksheet with no gaps
Also I have created a named range of the area from which I wish to copy called Order
Does this make any sense
Please Help.. I'm really struggling with this one
Bookmarks