Ashley1432
New Member
- Joined
- Aug 10, 2017
- Messages
- 8
I am creating customer collections letters and need to be able to add rows of data into the letter based on how many past due invoices the customer has. Each customer has its own tab, and the number of past due invoices is in cell B3 on each tab. I need a macro that will go to each tab and add X many rows (starting at row 8) based on the value in B3 on that specific tab. I'm horrible at macros and try to avoid them but I can't think of a way to do this otherwise. Please help! I will also need it to copy the equations down from row 7 if you want to help with that too ![Smile :) :)](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
<tbody>
</tbody>
A | B | C | |
1 | Cust:A111 | 3 | |
2 | |||
3 | |||
4 | Dr. Mr. Smith, | ||
5 | The following invoices are now past due. | ||
6 | |||
7 | # | Document # | Amt |
8 | 1 | 123456 | 71.00 |
9 |
<tbody>
</tbody>