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.
[TABLE="width: 1624"]
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Date[/TD]
[TD]Month[/TD]
[TD]Year[/TD]
[TD]Vendor[/TD]
[TD]Material[/TD]
[TD]Source[/TD]
[TD]Truck #[/TD]
[TD]Ticket Number[/TD]
[TD]Gross[/TD]
[TD]Tare[/TD]
[TD]Net[/TD]
[TD]Tonne[/TD]
[TD]Item Number[/TD]
[TD]Notes[/TD]
[TD]Cancelled?[/TD]
[/TR]
[TR]
[TD]April 20, 2017[/TD]
[TD]April[/TD]
[TD]2017[/TD]
[TD]Robert[/TD]
[TD]Granular A[/TD]
[TD]Omemee[/TD]
[TD]63[/TD]
[TD]3686[/TD]
[TD="align: center"]34070[/TD]
[TD="align: center"]12800[/TD]
[TD="align: center"]21270[/TD]
[TD="align: center"]21.27[/TD]
[TD="align: center"]6[/TD]
[TD]Dumped in Contractor Yard[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]April 24, 2017[/TD]
[TD]April[/TD]
[TD]2017[/TD]
[TD]Robert[/TD]
[TD]Granular A[/TD]
[TD]Omemee[/TD]
[TD]88[/TD]
[TD]3687[/TD]
[TD="align: center"]36640[/TD]
[TD="align: center"]13500[/TD]
[TD="align: center"]23140[/TD]
[TD="align: center"]23.14[/TD]
[TD="align: center"]6[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
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
[TABLE="width: 1624"]
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Date[/TD]
[TD]Month[/TD]
[TD]Year[/TD]
[TD]Vendor[/TD]
[TD]Material[/TD]
[TD]Source[/TD]
[TD]Truck #[/TD]
[TD]Ticket Number[/TD]
[TD]Gross[/TD]
[TD]Tare[/TD]
[TD]Net[/TD]
[TD]Tonne[/TD]
[TD]Item Number[/TD]
[TD]Notes[/TD]
[TD]Cancelled?[/TD]
[/TR]
[TR]
[TD]April 20, 2017[/TD]
[TD]April[/TD]
[TD]2017[/TD]
[TD]Robert[/TD]
[TD]Granular A[/TD]
[TD]Omemee[/TD]
[TD]63[/TD]
[TD]3686[/TD]
[TD="align: center"]34070[/TD]
[TD="align: center"]12800[/TD]
[TD="align: center"]21270[/TD]
[TD="align: center"]21.27[/TD]
[TD="align: center"]6[/TD]
[TD]Dumped in Contractor Yard[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]April 24, 2017[/TD]
[TD]April[/TD]
[TD]2017[/TD]
[TD]Robert[/TD]
[TD]Granular A[/TD]
[TD]Omemee[/TD]
[TD]88[/TD]
[TD]3687[/TD]
[TD="align: center"]36640[/TD]
[TD="align: center"]13500[/TD]
[TD="align: center"]23140[/TD]
[TD="align: center"]23.14[/TD]
[TD="align: center"]6[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
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