SOLVED

Show date of modification to one cell

%3CLINGO-SUB%20id%3D%22lingo-sub-3094423%22%20slang%3D%22en-US%22%3EShow%20date%20of%20modification%20to%20one%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3094423%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20set%20list%20of%20items%20and%20need%20to%20have%20a%20column%20that%20shows%20when%20the%20last%20time%20the%20cell%20next%20to%20it%20was%20modified.%20In%20the%20attached%20example%20column%20A%20will%20always%20be%20the%20same%2C%20column%20B%20will%20be%20modified%20periodically%20.%20I%20need%20column%20C%20to%20show%20the%20date%20of%20last%20modification%20of%20each%20items%20in%20column%20B.%20I%20know%20this%20can%20be%20achieved%20with%20VBA%20but%20have%20not%20really%20worked%20with%20VBA%20much.%20Column%20A%20will%20mostly%20likely%20have%20~5k%20items%20in%20it%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22excel%20exp.PNG%22%20style%3D%22width%3A%20597px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F343982iCE892EB9BF5B0883%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22excel%20exp.PNG%22%20alt%3D%22excel%20exp.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3094423%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3094554%22%20slang%3D%22en-US%22%3ERe%3A%20Show%20date%20of%20modification%20to%20one%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3094554%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1013768%22%20target%3D%22_blank%22%3E%40Pcesarrt26%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMaybe%20as%20shown%20in%20the%20attached%20file.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I have a set list of items and need to have a column that shows when the last time the cell next to it was modified. In the attached example column A will always be the same, column B will be modified periodically . I need column C to show the date of last modification of each items in column B. I know this can be achieved with VBA but have not really worked with VBA much. Column A will mostly likely have ~5k items in it 

excel exp.PNG

 

1 Reply
best response confirmed by Pcesarrt26 (New Contributor)
Solution

@Pcesarrt26 

Maybe as shown in the attached file.