Is it possible to loop along a row?
I have a header row of dates, I want to loop through those dates and if one of the dates is earlier than todays date I want an action to copy the content of the cells below and paste the values to override the formulas in that column.
I’ve done loops down a column before but I’m really struggling doing it along a row. any help or guidance would be greatly appreciated.
Thanks in advance 🙂