My process begins by opening "ExcelReport", https://app.box.com/s/2ieux0ws9c07k1d5x7rb, which is my source data. Then I open the file I've been working on "jmmac2", https://app.box.com/s/5sd1j11hjp9in7qc57os
I hit the Import button to get the source data into "jmmac2", then hit the Export button to create invoices. What it's doing now is executing through the filter line (the line just after Dim LastRow2), but rather than filtering any of the data, it hides all rows so the next line (Set rngUniques...) returns nothing.
Ideally "Export" will populate a series of worksheets, each named by the client name_invoice #, and the subsequent data will be dropped into each invoice. I have a blank invoice template as Sheet2 that is used to start each new invoice. The invoices each have a button that will transfer the information into a new Outlook message, then color the tab green to signify it has been sent. All other macros in this workbook are working perfectly, can anyone help me solve the problem above? It is in the "CopyData" macro.
Bookmarks