Excel: Replace values in rows after certain GAP of row numbers RRS feed

  • Question

  • I need to replace the value in a certain row that is repeated after a certain amount of rows. I have multiple excels I need to do this.

    Current data: 7th row: IN 16th row: IN ( comes after 9 rows) 25th row: IN ( comes after 9 rows)

    I need these values to be replaced by OUT.

    I did some research and seems like I could use Macros but I am not familiar with Macros.

    Can anyone please help with macros with a loop or suggest any other ideas?

    Monday, July 8, 2019 10:23 AM