vickroycomputers
New Member
- Joined
- Jun 4, 2015
- Messages
- 2
Hi there! I have a problem that has me stumped...
I have a workbook with 5 worksheets.
We fill out qty for a bunch of items on the first sheet.
Then a labor invoice and 3 material order forms auto populate. That I've got down.
I need a final contract page to populate, only with the items that have nonzero qty fields on the labor invoice and material order forms, ideally it should start at one page and grow based on the number of items entered, but I could deal with a 2 page contract with some blank spaces - as long as the blank spaces only appear at the end, I.e. after the data with nonzero qtys are displayed. Also I have, say 60 items across the data sheets but am never likely to use more than 20 or so on any given contract, so I'd like to not have 60 blank lines waiting for data on the contract sheet
I hope that makes sense! And I hope someone can help!
Thanks,
-Mark
I have a workbook with 5 worksheets.
We fill out qty for a bunch of items on the first sheet.
Then a labor invoice and 3 material order forms auto populate. That I've got down.
I need a final contract page to populate, only with the items that have nonzero qty fields on the labor invoice and material order forms, ideally it should start at one page and grow based on the number of items entered, but I could deal with a 2 page contract with some blank spaces - as long as the blank spaces only appear at the end, I.e. after the data with nonzero qtys are displayed. Also I have, say 60 items across the data sheets but am never likely to use more than 20 or so on any given contract, so I'd like to not have 60 blank lines waiting for data on the contract sheet
I hope that makes sense! And I hope someone can help!
Thanks,
-Mark