Hey guys,
I am looking for help with some VBA code to insert a row based on the data either above or below the row. In the data set I have, column A contains the year and column B contains the month. I can have more than two rows of the same month and year, so I may have more than 12 rows containing the same year. What I am wanting to achieve is insert one row (two would be best) between years 2020 and 2021 and 2022 and so on. Can anyone help?
I am looking for help with some VBA code to insert a row based on the data either above or below the row. In the data set I have, column A contains the year and column B contains the month. I can have more than two rows of the same month and year, so I may have more than 12 rows containing the same year. What I am wanting to achieve is insert one row (two would be best) between years 2020 and 2021 and 2022 and so on. Can anyone help?