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
37 freelancers are bidding on average €31 for this job
I can create a macro which will follow the steps mentioned by you in the project description I am an excel expert with rich knowledge in advance excel, macros. If you are interested then ping me in chat.