I currently use 2003, 2007 and 2010 versions of Excel, and do know how to record and run a macro, though I do not write VB. I have an invoice template which I bring in, fill in individual details using data validation/drop down boxes) and print off. I then want to be able to copy, for instance, data in cells c21, c12, e18, and g59 (in that order) to an external workbook in a row format so that at end of each month I have date, name, ref and total in tabular format. I can easily write the macro copying the data over to the other workbook but can't get it to move down one line so that when I copy a subsequent invoice data over, it doesn't overwrite what was previously pasted. I would appreciate any help.