Extend excel list via VBA macro automatically

Job ID: 34035166

Budget: €8 – €30 EUR

Good day,



I am looking for a VBA macro that automates a relatively complex behavior to expand an Excel list. The problem is that the amount of rows to be copied is absolutely dynamic.

For this I can read the number of rows with a formula and maybe give this number to the macro, so that it knows how many new rows the Excel list (table 1) has to be extended downwards.

It would be really great if someone can write a macro for this :)



I try to show step by step what this macro should do. I call the variable number of rows x.

Step 1 Copy

Copy the following rows from table 2 to table 1:

The macro must always start copying in the last row of table 1 and this downwards around the variable x.

A2 to Ax in B

B2 to Bx in C

C2 to Cx in D

D2 to Dx in F

At the end set a colored blank line (after this line, the next copy would take place)



Step 2 Extend standard rows by the new rows Table 1

Write today's date in column A, but only in the newly inserted rows.

Write letter K in column E, but only in the newly inserted rows.



Step 3 Extend standard formulas by the new rows Table 1

Extend the formula from column G by the new rows.

Extend the formula from column H by the new rows.

Extend the formula from column Q by the new rows.

Extend the formula from column T by the new rows.



Step 4 Place single formulas in the empty row Table 1

Set formula from cell I3 into the new empty row Ix

Set formula from cell J3 into the new empty row Jx

Move formula from cell K3 to new empty row Kx

Set formula from cell M3 to the new empty row Mx

Write today's date into cell Ux of the new empty row



Step 5 Place special formulas in the empty row Table 1

Set formula from cell L3 into the new blank row Lx

Place a formula from cell M3 in the new empty row Mx

Set formula from cell R3 to the new empty row Rx

Set formula from cell S3 to the new empty row Sx
Related categories: Visual Basic Excel