Okay ... once again thank you to everyone who has helped me get this far .... The new challenge ... record my sales and inventory. I want to thank Richard Buttrey, for giving me this piece of code ...
What i would like is to use this idea to keep track of my innovatory ... Basically i would like this code to add the Entry in too a new sheet, and then to reduce an indicator for innovatory ...![]()
Sub AddData() Range("A5").EntireRow.Insert Range("DataEntry").Copy Destination:= Range("A5") End Sub
Bookmarks