Macro to fill down formula every three rows

[wilhan01]

I have a long list of data in column A in trios of data. The first cell is blank but will be a formula and the next two are pieces of data. It repeats like this down the column. I need a way of filling down the formula every three rows but also preserving the data that is already in that column. Dummy data attached. It shows what the end result should look like. I just need a way to automate it in a long list.Fill Down.xls

[JieJenn]

Please Login or Register  to view this content.