How, in VBA, can I make my macro go through rows and if the word "Total" is in column D than go to the last cell in the row and if it has "Total" than go to the next row, and if the last cell is not "Total", then put "Total" in the next empty cell in that row, and then go to the next row until complete. Thanks for help, I have been trying to do this all day