I have 4 Excel tables (cash flows) on 1 sheet and would like to insert a VBA code to adjust the number of rows by changing the value in a single cell (Summary!H9 - Term in amount of years) on another sheet (Summary!). The added rows should contain the same formulas as the rows above. The current tables (CF!A11:J37);(CF!L11:T37);(CF!V11:AB37) & (CF!AD11:AJ37) consists of 5 columns and 27 rows (1st row is the headers and 0 year follows in 1st column 2nd row, 1st year in 1st column 3rd row). The minimum numbers years must be 2 for all the cashflows. I'm new to VB codes and would appreciate step-by-step guidance. Please let me know what further info is required.Many thanks!