Variable=2 - Duplicate Row - Divide data by Variable - can anyone help me with this?

Hi All,

I have put together a dummy spreadsheet for this query (Please see attached Fig 1 and Excel Forum Sheet).

I want to create a macro that when it runs, it reads the varible and duplicates that row. So if that row has a vairable of 2 i want it to duplicate it by 1 row so in total i have 2, if it has a variable of 3 then duplicate it 2 times so i have it 3 times. I also want the data in the data fields to be divided by the variable.

Would really appreciate all you help with this.

Many Thanks

Maverick