Hi all, I need help on vba code to copy data from sheet 1 and paste in sheet 2. But the range to copy the data is different from the range to copy the data, for example : copy from ("R20") and paste in ("T10"). The "sheet 2" is a invoice, There is around 15 rows in sheet 1. so, it would be great if i can choose the row number to copy the data. Thanks in advance. Attached sample workbook. Refer this link: http://www.excelforum.com/excel-gene...-data-vba.html