Copying Rows within the same sheet to create a table

[airdrawndagger]

Hello Fellas,

Im totally a newbie to VBA and Excel.

What I am trying to achieve is the following:

I have set up the attached sheet. From Row 598 to 606 I have reference table which I want to conditonally move the row(s) to the row 3 and onwards. However the calculation will be as follows :

If the value of Cell A2 is somewhere between 250 to 500 then the rows 598 and 599 should be copied to the row 3 and 4. If the value is between 500 - 1000 then 598, 599 and 600 should be moved to 3,4 and 5, etc.

I would simply want to input the number in A2 and the rest should be formatted automatically. I couldn't build up the logic. Can you help me on this? I am using Excel 2010

Thanks.

NomadixBoM.xlsm

[Sanish Tirkey]

Use IF....Then...Else at the destination cells by putting conditions on A2. If you want a macro to do this, it would need the exact cell locations.

[airdrawndagger]

Hi,

IF ELSE did not work for me as it does not transfer the formatting. I will need the macro, but simply the macro will always use the same source and destination cells.

[AB33]

And what would happen to the values in 601 to 606?

[airdrawndagger]

They will not change, they will only be a reference table inside this sheet.