Magoosball
Board Regular
- Joined
- Jun 4, 2017
- Messages
- 70
- Office Version
- 365
I am trying to write a script that will do the following:
This should continue until the last row of the worksheet as dictated by no date in column A.
This is going to be ran daily to put today's date into Column N, O, P. This is why it is important to check to see if that column is empty before continuing.
- Check to see if column N is empty. If column N isn't empty then go onto the next row. If it is empty then check to see if Column F contains the word "January". If Column F contains that word then put today's date into Column N.
- Check to see if column O is empty. If column O isn't empty then go onto the next row. If it is empty then check to see if Column F contains the word "February" OR "March". If Column F contains either of those words then put today's date into Column O.
- Check to see if column P is empty. If column P isn't empty then go onto the next row. If it is empty then check to see if Column F contains the word "April" OR "May" OR "June". If Column F contains any of those words then put today's date into Column P.
This should continue until the last row of the worksheet as dictated by no date in column A.
This is going to be ran daily to put today's date into Column N, O, P. This is why it is important to check to see if that column is empty before continuing.