b_choplick
New Member
- Joined
- Jul 17, 2014
- Messages
- 9
I would like to create a Macro that creates a new blank word document, then checks values in a column of cells. The macro will check the value of each cell range, and if the value of the cell is greater than $0.00, it will select a specific worksheet in the workbook that is relevant to that specific cell's data and copy the entire sheet into the word document. For example, if A1 > $0.00, Sheet2 will be copied into the word document followed by a page break. If A2 > $0.00, Sheet 3 will be copied into the word document followed by a page break, etc. I think that I'll need an IF statement for each cell (which is fine), but am not sure how to create the word document and then copy and paste the correct sheet into the word document.