Hi, wondering if someone can help write some VBA code for an Excel sheet I have?
When I type CTRL-R, I'd like to have:
1) the current date update in column G of the row where the active cell is, format 'm/d/yyyy'.
2) a "1" added to the value in the cell column H of the row where the active cell is; currently that cell could have a # in it already, or it could be empty.
Many thanks!!
When I type CTRL-R, I'd like to have:
1) the current date update in column G of the row where the active cell is, format 'm/d/yyyy'.
2) a "1" added to the value in the cell column H of the row where the active cell is; currently that cell could have a # in it already, or it could be empty.
Many thanks!!