I am trying to create a macro that would have rows repeat, with the addition of a sequentially increasing number at the end of certain, corresponding cells (starting with the number 30 to number 60, say).

For example:

Apple_V30, Pear_V30, Orange_V30, Apple_V31, Pear_V31, Orange_V31

The comma signifies the boundary of a cell. I am looking to do this for the header row.

Please let me know if I should clarify.