Forum Discussion
LilYawney
Mar 23, 2023Brass Contributor
VBA coding help
Hey guys! I need some help! So my company has a "Master Project List" spreadsheet that summarizes the important information of all projects into one place. I currently have a VBA code that I...
- Mar 27, 2023
I've added the worksheet change event to your worksheet "Master Project List" for entries in range M6:M200. If i enter a value in any of these cells the current date and time is entered in the adjacent cell of column N.
LilYawney
Mar 23, 2023Brass Contributor
This code still changes all cells in column N
OliverScheurich
Mar 23, 2023Gold Contributor
The code returns the expected result in my file. Can you attach your file without sensitive data?
- LilYawneyMar 27, 2023Brass Contributor
Sorry for the delayed response but here's a copy of the MPL Spreadsheet without any sensitive information!
- OliverScheurichMar 27, 2023Gold Contributor
I've added the worksheet change event to your worksheet "Master Project List" for entries in range M6:M200. If i enter a value in any of these cells the current date and time is entered in the adjacent cell of column N.
- LilYawneyMar 27, 2023Brass ContributorThat worked perfectly! Thank you!