update date

Hi all This works if the cell is physically changed in column E. Private Sub Worksheet_Change(ByVal Target As Range) 'add date when status changes Dim WorkRng As Range Dim Rng As Range Dim xOffsetColumn As Integer Set WorkRng = Intersect(Application.ActiveSheet.Range("e:e"), Target)...

Good afternoon all, I have a workbook that has sheets for each month and tracks job requests, and the progress of said jobs. Every month, I copy the previous sheet, and update the sheet name to reflect the new month (format i.e "2.1 - 2.29", "3.1 - 3.31"). I've attached the XL2BB data for the...

i have an inventory list. the prices keep updating. as of now there is no track to when a row (be it the cost price, sell price, vendor, packing, etc) was edited. i would like to create a new column "Updated On" which stores the date whenever a row is edited. if a row is updated twice is it...

Delete Thread

Hi all, My name is Fabrizio and I am relatively new in the excel world. What I would like to do is build a sort of inventory of chemicals in my lab. I have prepared an excel sheet with four columns: A) name of the chemical; B amount, C) reference number and D) location, plus two rows at the...

Hi, I am working on a spreadsheet where I wish to have a column B where each cell shows the date on which the cell in the corresponding row of column A is manually updated by me. In other words, <table style="border-collapse: collapse;" border="0" cellpadding="0" cellspacing="0" width="484"...