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 freelances font une offre moyenne de 31 € pour ce travail
Greetings! Thanks for detailed steps. With macros, it is possible to implement really complex functionalities. I think in your case it is possible to do complete automation (manual steps that you have listed like "For Plus
Hello! I'm interested in your project. Your task is clear to me and I am ready to solve it. I have extensive and successful practical experience in processing and analyzing data in Excel, including using formulas and m Plus
Hi there myself yesu I am a vba developer I can do this you can contact me on this for further discussion thanks
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.
Good Day I can help to you write macro with your requirements . Must see file will have some questions Can do within few hours I have 15+ year experience of Excel, Excel VBA So, you can trust to me. Result will be exc Plus
Hi there - This can be done. I just did a similar project where I got this input through an userform than a formula. However, the task is similar where a qty and a start number will be given and the rows should be po Plus