Hi,
I'm trying to create a formula that will copy all data in a row down to a new row, only if a certain criteria is met (as in win/lose, yes/no etc), else a new line is created with no copied data.
The rows also need to be numbered. For example, if the certain criteria is met, then a new row is created, all data copied down and the first cell of the row is now row "2". However, if the criteria is not met, the new row has no copied data and the new row is now row "1" again (back to the start of the pattern, so to speak).
If anyone can provide help on this I'd really appreciate it!.
I'm trying to create a formula that will copy all data in a row down to a new row, only if a certain criteria is met (as in win/lose, yes/no etc), else a new line is created with no copied data.
The rows also need to be numbered. For example, if the certain criteria is met, then a new row is created, all data copied down and the first cell of the row is now row "2". However, if the criteria is not met, the new row has no copied data and the new row is now row "1" again (back to the start of the pattern, so to speak).
If anyone can provide help on this I'd really appreciate it!.