Hi,

I am trying to expand my dataset by copying rows and changing one cell within each row when it is copied.

In Column M there is an ID. The ID repeats on many rows because it has data on many different dates (Column O)

In general, the dates are generally at the end of a quarter. They are usually March 31st, June 30, Sep 30, Dec. 31st. There is usually not data in between, so I need to fill the data in between the quarters. Sometimes, the date could be August, or July, or any month really.

So lets say the ID is 1 and the Date is Mar 31st. I would want to copy the row twice. One time I would copy it Feb 28th and the other time to Jan 31st.

However, sometimes there is already a row with ID 1 and Date Feb 28th. If this is the case, I would not want copy the row this time.

Also, when I speak about dates, all that really matters is the year and the month, so I can reformat the dates to make that easier.

I have attached a sample file with two tabs, Input and Output. In the output, a copied row is indicated by the green color. Please note the instance when there are NOT two green rows above a white row. This occurs because this row already appears.

Any help you guys could give me would be greatly appreciated. I am really really stuck and this would save my life. Please let me now if you could help.

Sincerely,

Michael