Good Day,
I hope this question finds you well.
I have a sheet with some columns that needs to be populated by people in my team. Once a person changes a value in any cells for columns A, E, F, G, H it should populate the updated date and username automatically (this seems to work but not always for some reason).
From this updated date in Column I, I would like the year, week number, and the date for that particular week (starting on a Monday) to be populated each time. With that said, once this update occurs based on the original date value in column I, it should not change the values in Column I or J. I hope this makes sense.
I have read a few article on forums, but can not find something that works for me as I am not an vba expert.![]()
Basically column I and J is populated once anything changes in certain columns and then column I (green) is used to populate the yellow columns without changing the exiting column I and J again.
I have even tried the more basic WEEKNUM, but then nothing works column I and J. I would rather have everything running from vba to be automatic without dragging or adjusting formulas in sheets when data row entries increases over time.
Attached is a example file.
I thank you in advance.
Kind Regards,
Ray
Bookmarks