Ditutup

Extend excel list via VBA macro automatically

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

Kemahiran: Excel, Visual Basic

Tentang Klien:
( 0 ulasan ) Frankfurt am Main, Germany

ID Projek: #34035166

37 pekerja bebas membida secara purata €31 untuk pekerjaan ini

(484 Ulasan)
8.4
(496 Ulasan)
8.4
(484 Ulasan)
7.8
(230 Ulasan)
7.0
ksriniravi

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 Lagi

€30 EUR dalam sehari
(253 Ulasan)
7.1
(217 Ulasan)
6.6
(435 Ulasan)
6.7
SShtv

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 Lagi

€30 EUR dalam sehari
(121 Ulasan)
6.5
(174 Ulasan)
6.7
(150 Ulasan)
6.0
PERPETUAL0

Hello there i can done it within very short time regard ilyas

€45 EUR dalam 2 hari
(136 Ulasan)
5.8
(58 Ulasan)
5.5
(41 Ulasan)
5.7
(25 Ulasan)
5.6
(86 Ulasan)
4.9
(22 Ulasan)
4.8
yesubabu10203

Hi there myself yesu I am a vba developer I can do this you can contact me on this for further discussion thanks

€30 EUR dalam 2 hari
(30 Ulasan)
4.7
vishal54sharma

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.

€20 EUR dalam sehari
(43 Ulasan)
4.2
MamukaB

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 Lagi

€20 EUR dalam sehari
(29 Ulasan)
4.3
edatawiz

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 Lagi

€24 EUR dalam 7 hari
(18 Ulasan)
4.0