Insert rows with formulas and formatting based on cell variable

[LEWI_74]

Good morning,

I have a variable in cell A1 and a two row table from A3:C5 (when A1 = 0) with formulas (looking up from another sheet) and border formatting.

When the variable in A1 changes for example to 4, I would like 4 additional rows added to the table (with formulas and formatting), taking the table range to A3:C9

Likewise, when using the same file again, if the variable in cell A1 is now 2, I would like the table to be from A3:C7 (with formulas and formatting).

I am a VBA newbie and despite looking up across the internet for solutions, I haven’t been successful.

Could someone help please?

Thanks in anticipation.

David