Macro for Adiing rows with keeping cell formating and formulas depending on value from single cell

[chobanne]

Hi i need a macro who will add a rows to a tables in various worksheet depend on values in one single cell with keeping formating and formulas from row above the added ones.

example:

Single cell (A1) on sheet1 (named "enter") have a value 5, that mean that new 4 rows must be add after the last row in specific tables in Sheet1(enter) after B50:K50 and in Sheet2 (named "exit") after A55:D55, K33:M45 and AC67:AK:67. And off course i ll need to keep all formating and formulas from row above the added rows in added rows. i hope u understand what i want

Thank you, i hope this is not hard and wont take your time

 

[chobanne]

Hi i need a macro who will add a rows to a tables in various worksheet depend on values in one single cell with keeping formating and formulas from row above the added ones.

example:

Single cell (A1) on sheet1 (named "enter") have a value 5, that mean that new 4 rows must be add after the last row in specific tables in Sheet1(enter) after B50:K50 and in Sheet2 (named "exit") after A55:D55, K33:M45 and AC67:AK:67. And off course i ll need to keep all formating and formulas from row above the added rows in added rows. i hope u understand what i want

Thank you, i hope this is not hard and wont take your time

Can anyone help?