Der Kampher
New Member
- Joined
- Apr 28, 2017
- Messages
- 1
Currently have a material tracking workbook which uses a table for organizing. I am hoping someone can help me with producing a code in marco which will insert a new row to "cancel" a specific item by showing the negative value underneath.
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
When Column P contains the word "Yes", then insert a row underneath which contains the same information as the row above.
Columns B, C, K, and L have formulas which reference the manually entered columns to produce results.
The other columns will need to carry forward with their data except for Columns I and J which need to been shown a negative inverse.
Any help would be appreciated.
Thank you
| Date | Month | Year | Vendor | Material | Source | Truck # | Ticket Number | Gross | Tare | Net | Tonne | Item Number | Notes | Cancelled? |
| April 20, 2017 | April | 2017 | Robert | Granular A | Omemee | 63 | 3686 | 34070 | 12800 | 21270 | 21.27 | 6 | Dumped in Contractor Yard | Yes |
| April 24, 2017 | April | 2017 | Robert | Granular A | Omemee | 88 | 3687 | 36640 | 13500 | 23140 | 23.14 | 6 |
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
When Column P contains the word "Yes", then insert a row underneath which contains the same information as the row above.
Columns B, C, K, and L have formulas which reference the manually entered columns to produce results.
The other columns will need to carry forward with their data except for Columns I and J which need to been shown a negative inverse.
Any help would be appreciated.
Thank you
