Hi, this is probably a very simple question but my brain is blank!
I need to create a macro where, if someone enters a new row into a spreadsheet it will automatically populate 2 fields.
The users will use the Insert Row command to enter a row, so I think I need an if statement to say IF new row inserted then populate column A with a Value of "Open" and populate column B with a Value of Today's Date (then to be held as a static date)
Hopefully this makes sense!
I need to create a macro where, if someone enters a new row into a spreadsheet it will automatically populate 2 fields.
The users will use the Insert Row command to enter a row, so I think I need an if statement to say IF new row inserted then populate column A with a Value of "Open" and populate column B with a Value of Today's Date (then to be held as a static date)
Hopefully this makes sense!
