I need a Macro to help me with this!

[BrickCityDevil]

I have an Excel sheet used for tracking Inventory and I want to be able to monitor all changes in Inventory. I have a column for Quantity Received and another Column Quantity Signed out. I would like for if either Column is Greater than zero to issue a statement in another cell or on another page or worksheet (either one is acceptable) the current date, Item Description, "Quantity Received" or "Quantity Signed out" that value and the Quantity on hand. If there is no change then I dont want a message to be issued.
I have a cloumn that already calculates the value on hand given the quantity received or the quantity signed out.
Here is an example of the lay out.(Item Description is Column B and so forth)
<TABLE style="WIDTH: 878pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=1168 border=0><COLGROUP><COL style="WIDTH: 181pt; mso-width-source: userset; mso-width-alt: 8813" width=241><COL style="WIDTH: 145pt; mso-width-source: userset; mso-width-alt: 7058" width=193><COL style="WIDTH: 55pt; mso-width-source: userset; mso-width-alt: 2669" span=2 width=73><COL style="WIDTH: 102pt; mso-width-source: userset; mso-width-alt: 4973" width=136><COL style="WIDTH: 90pt; mso-width-source: userset; mso-width-alt: 4388" width=120><COL style="WIDTH: 76pt; mso-width-source: userset; mso-width-alt: 3693" width=101><COL style="WIDTH: 65pt; mso-width-source: userset; mso-width-alt: 3145" width=86><COL style="WIDTH: 109pt; mso-width-source: userset; mso-width-alt: 5302" width=145><TBODY><TR style="PAGE-BREAK-BEFORE: always; HEIGHT: 16.5pt" height=22><TD class=xl67 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: red 1.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 181pt; BORDER-BOTTOM: red 1.5pt solid; HEIGHT: 16.5pt; BACKGROUND-COLOR: yellow" width=241 height=22>ITEM DESCRIPTION</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: red 1.5pt solid; BORDER-LEFT-COLOR: windowtext; WIDTH: 145pt; BORDER-BOTTOM: red 1.5pt solid; BACKGROUND-COLOR: yellow" width=193>PART NUMBER</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: red 1.5pt solid; BORDER-LEFT-COLOR: windowtext; WIDTH: 55pt; BORDER-BOTTOM: red 1.5pt solid; BACKGROUND-COLOR: yellow" width=73>MAKE</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: red 1.5pt solid; BORDER-LEFT-COLOR: windowtext; WIDTH: 55pt; BORDER-BOTTOM: red 1.5pt solid; BACKGROUND-COLOR: yellow" width=73>INITIAL QTY</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: red 1.5pt solid; BORDER-LEFT-COLOR: windowtext; WIDTH: 102pt; BORDER-BOTTOM: red 1.5pt solid; BACKGROUND-COLOR: yellow" width=136>QUANTITY RECEIVED</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: red 1.5pt solid; BORDER-LEFT-COLOR: windowtext; WIDTH: 90pt; BORDER-BOTTOM: red 1.5pt solid; BACKGROUND-COLOR: yellow" width=120>QTY SIGNED OUT</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: red 1.5pt solid; BORDER-LEFT-COLOR: windowtext; WIDTH: 76pt; BORDER-BOTTOM: red 1.5pt solid; BACKGROUND-COLOR: yellow" width=101>QTY ON HAND</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: red 1.5pt solid; BORDER-LEFT-COLOR: windowtext; WIDTH: 65pt; BORDER-BOTTOM: red 1.5pt solid; BACKGROUND-COLOR: yellow" width=86>UNIT COST</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: red 1.5pt solid; BORDER-LEFT-COLOR: windowtext; WIDTH: 109pt; BORDER-BOTTOM: red 1.5pt solid; BACKGROUND-COLOR: yellow" width=145>TOTAL VALUE ON HAND</TD></TR><TR style="HEIGHT: 21pt" height=28><TD class=xl68 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 21pt; BACKGROUND-COLOR: #d8d8d8" colSpan=9 height=28>Location 4 C 2</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl66 style="BORDER-RIGHT: #3f3f3f 0.5pt solid; BORDER-TOP: #3f3f3f 0.5pt solid; BORDER-LEFT: #3f3f3f 0.5pt solid; BORDER-BOTTOM: #3f3f3f 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: #f2f2f2" height=20>Inside Door Handles Right</TD><TD class=xl66 style="BORDER-RIGHT: #3f3f3f 0.5pt solid; BORDER-TOP: #3f3f3f 0.5pt solid; BORDER-LEFT-COLOR: #3f3f3f; BORDER-BOTTOM: #3f3f3f 0.5pt solid; BACKGROUND-COLOR: #f2f2f2">19552-01</TD><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8"></TD><TD class=xl64 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8">23</TD><TD class=xl64 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8"></TD><TD class=xl64 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8"></TD><TD class=xl64 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8">23</TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8">$ 26.00 </TD><TD class=xl63 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8" align=right>$598.00</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl66 style="BORDER-RIGHT: #3f3f3f 0.5pt solid; BORDER-LEFT: #3f3f3f 0.5pt solid; BORDER-TOP-COLOR: #3f3f3f; BORDER-BOTTOM: #3f3f3f 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: #f2f2f2" height=20>Inside Door Handles Left</TD><TD class=xl66 style="BORDER-RIGHT: #3f3f3f 0.5pt solid; BORDER-LEFT-COLOR: #3f3f3f; BORDER-TOP-COLOR: #3f3f3f; BORDER-BOTTOM: #3f3f3f 0.5pt solid; BACKGROUND-COLOR: #f2f2f2">19551-01</TD><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8"></TD><TD class=xl64 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8">23</TD><TD class=xl64 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8"></TD><TD class=xl64 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8"></TD><TD class=xl64 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8">23</TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8">$ 26.00 </TD><TD class=xl63 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8" align=right>$598.00</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl66 style="BORDER-RIGHT: #3f3f3f 0.5pt solid; BORDER-LEFT: #3f3f3f 0.5pt solid; BORDER-TOP-COLOR: #3f3f3f; BORDER-BOTTOM: #3f3f3f 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: #f2f2f2" height=20>Barn Door Handle Left</TD><TD class=xl66 style="BORDER-RIGHT: #3f3f3f 0.5pt solid; BORDER-LEFT-COLOR: #3f3f3f; BORDER-TOP-COLOR: #3f3f3f; BORDER-BOTTOM: #3f3f3f 0.5pt solid; BACKGROUND-COLOR: #f2f2f2">4C3Z78431A03AB</TD><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8">Ford</TD><TD class=xl64 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8">4</TD><TD class=xl64 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8"></TD><TD class=xl64 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8"></TD><TD class=xl64 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8">4</TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8">$ 51.76 </TD><TD class=xl63 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8" align=right>$207.04</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl66 style="BORDER-RIGHT: #3f3f3f 0.5pt solid; BORDER-LEFT: #3f3f3f 0.5pt solid; BORDER-TOP-COLOR: #3f3f3f; BORDER-BOTTOM: #3f3f3f 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: #f2f2f2" height=20>Barn Door Handle Right</TD><TD class=xl66 style="BORDER-RIGHT: #3f3f3f 0.5pt solid; BORDER-LEFT-COLOR: #3f3f3f; BORDER-TOP-COLOR: #3f3f3f; BORDER-BOTTOM: #3f3f3f 0.5pt solid; BACKGROUND-COLOR: #f2f2f2">YC3Z7843400AB</TD><TD style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8">Ford</TD><TD class=xl64 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8">7</TD><TD class=xl64 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8"></TD><TD class=xl64 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8"></TD><TD class=xl64 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8">7</TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8">$ 36.07 </TD><TD class=xl63 style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8" align=right>$252.4</TD></TR></TBODY></TABLE>

 

[texasalynn]

do not start new threads - continue with questions in original post

duplicate
http://www.mrexcel.com/forum/showthread.php?t=372086

 

[BrickCityDevil]

I apologize