Excel Macro - Insert Cellls Based On Cell Value

[MathewH93]

Hello

Using Excel 2007.. I need to find a way to insert cells based on a cell value, for example if cell D2 says "4" then I need a macro that can insert that amount of rows.

To make things more complicated, I will need to ensure that the macro inserts rows after the row with a specific text string.

For example I enter "@@@" in cell A50 and then I need the macro to insert the amount of rows displayed in cell D2 after that row.

The row at which I enter "@@@" will be different each time but the cell which displays the amount of rows to enter will be the same.

Is this possible?

I forgot to add that once the rows have been inserted, I will then need to copy a formula into those rows.

Many Thanks.

Matt

 

[farmerscott]

Matt,

welcome to the forum.

Can you post a sample of your data and what it will look like after the code is run.

thx

FarmerScott

 

[MathewH93]

Hi Scott,
Thanks for your reply.

Could you provide me an email address so I can attach the file, I wont be able to explain exactly what I need using this thread and it will be easier to understand when you see the file.

Cheers

Matt

 

[farmerscott]

Matt,

Try one of these Excel jeanie, MrExcel HTML Maker or Borders-Copy-Paste and post your data back on the thread.

If you have trouble just 'private message' me and I will give you my email.

FarmerScott