b_choplick
New Member
- Joined
- Jul 17, 2014
- Messages
- 9
Hello
I have a workbook with 20+ sheets. All of these sheets relate to the "Summary" sheet. I would like to create a macro that checks certain cells in the Summary sheet (ex. A1:A8), and if the value in that cell is greater than $0.00, the macro will choose the appropriate sheet that relates to that cell and put it in a word document then continue checking the Summary sheet range for other cells with a value greater than $0.00 and continue that. All of the sheets should be pasted into Word on the SAME document with a page break between pages. I have started writing a macro that uses basic IF statements for each appropriate cell in the Summary sheet, but don't know how to use the macro to copy that sheet and paste it in a document as well as paste further sheets to the document.
I have a workbook with 20+ sheets. All of these sheets relate to the "Summary" sheet. I would like to create a macro that checks certain cells in the Summary sheet (ex. A1:A8), and if the value in that cell is greater than $0.00, the macro will choose the appropriate sheet that relates to that cell and put it in a word document then continue checking the Summary sheet range for other cells with a value greater than $0.00 and continue that. All of the sheets should be pasted into Word on the SAME document with a page break between pages. I have started writing a macro that uses basic IF statements for each appropriate cell in the Summary sheet, but don't know how to use the macro to copy that sheet and paste it in a document as well as paste further sheets to the document.
