I have work sheet with two sheets, sheet A we keep track of our inventory sheet B we use to add and decrease items we sell, I need VBA code that every time we add new items the date will be stamped automatically in column A in sheet B, also when we change price code in add/decrease page we need that code to be transferred to inventory sheet and change.
Please note our spread sheet has 8000 items and decrease page could have many duplicate entries.
Thank you for your help.
Bookmarks