I have a spreadsheet I use at work to monitor incoming stock, it has two
spreadsheets "Inbound" and "Order No".

Inbound shows in cells :E6 to AE729 the quantity that is arriving by product
and by week
Order No shows in the same cells the order no of the quantity that is
arriving

To make it far easier to read I would like for each cell in "Inbound" where
the quantity is greater than 0 a comment box to be inserted automatically
with the value from the same cell in the "Order No" sheet

For example if INBOUND E15 is greater than 0 then a comment box is inserted
stating the value in ORDER NO E15

Also though I need the comment boxes removed if the cell equals zero at a
later date.

I hope this is clear and am greatful for all help

TIA