I have a workbook with 3 worksheets (attached). I'm trying to copy data (A1:D13) from Sheet2 and paste it on desired word document while removing the rows whose column A values are 0.
I have created a button and added some vba code to do the job. The problem I'm facing is each time I hit the button in Sheet2 the copied data is pasting on the very first page of the word document and not creating a new page with the same header as in Page 1 of the document and also the cells are not auto fitted in the word document.
Please help !!!
Bookmarks