PDA

View Full Version : VBA to group matching data and copy for printing



steve400243
12-14-2016, 12:06 PM
Hello, On this worksheet I am get trying to get a VBA Code that will group the Booking# (Column I) and copy the data to the cell’s on the Invoice Tab and print all the invoices. There is several like Booking# on the Traffic Mitigation tab. In the example attached there are 13 different Booking #. So my end result would be to click on cell L1, ‘Traffic Mitigation fee Invoice’ Tab, and have 13 Invoice sheets print out. I put the information from row 11 in manually on the Invoice tab to show what I would like it to look like. Rows 3, and 5 is the data that would change for each printout. Other Rows would stay the same for each printout. Thanks for any help in advance.