So I'm creating an inventory spreadsheet that I will manually update every day. What I need is a cell that generates a timestamp the moment the "On Hand" "Purchase order" "Sales order" or Available" rows see any change to any of their values. I'm new to excel and I'm not quite sure how I'd even begin to go about this.
You would utilize the worksheet_change event for the occurrence. Say for example the "On Hand" column is column A and you want the timestamp in column B;
Please Login or Register to view this content.
If you are happy with my response please click the * in the lower left of my post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks