Autofill rows, 1 by 1 when executing a macro

[mterrazas]

Hello Guys,

I'm new in macros world, today I'm trying to make a macro to add 1 row at the bottom of my table every time I execute a macro, the new row must be add with "autofill" because I have some cells with list and dependent lists. Every time i execute my macro i need to autofill a new row from column "A" to "G" for example, at beging I'll have data in cells from "A3" to "G3", if i execute the macro a new line will be autofilled "A4" to "G4" but data in cells "D4" to "G4" must be blank so i can select new values from the lists, and if i execute the macro the range "A4" to "G4" must be autofilled to create "A5" to "G5" and the new cell must be blank.
the code i already have only add me 1 row, but if i execute it again nothing happens, this code is:

Please Login or Register  to view this content.

There you have some picts to show a better example:
Thats before executing the macro:
asasasasasasas.PNG

Thats after executing the macro:
dgdsfgfdg.PNG

Hope you can help me, thanks!

[Bernie Deitrick]

Try code like

Please Login or Register  to view this content.

[mterrazas]

Hello Bernie, the code worked partially, the thing is, i need to use autofill because some cell have lists taken from other table, if i copy&paste this list won't show off

Thank you!

[Bernie Deitrick]

Well, the macro can fill your table from the other table - you just need to explain the logic and show the layout of the other table.

[daboho]

Perhab like this if use autofill

Please Login or Register  to view this content.

[jeffreybrown]

Hi daboho,

Purely an observation. Since this OP is new to macros, might it be helpful to declare a variable with the words versus the declaration character?

This is...

Please Login or Register  to view this content.

Equal to...

Please Login or Register  to view this content.

Again, only an observation and I put the above for the OP as I know you know this already.

[mterrazas]

I can't upload the document, so i'll try to explain it, the table i want to add rows is in sheet "Datos", you can se a green button with "+" sign that execute the macro.
Data in column "D" & "E" could be selected form a drop-down list from tables in sheet "Listas Desplegables", this list are made with "Data validation" and are direct values.
Data in column "F" could be selected from a drop-dwon list from tables in sheet "Listas Desplegables", this list are made using "Data Validation" and are indirect values depending on values of column "E"
Data and fx in columns "A" & "B" are for other functions i'll add later.

Thank you again!

[mterrazas]

Here is my document, you can see it in the link, i think im not explaining properly, just paste everything together

https
:
//
we.
tl/t-zhuOq2SeKa

[mterrazas]

Hello daboho, i tried this code, but when i execute it an error 1004 apears

[Bernie Deitrick]

To get the data validation onto those cells, try:

Please Login or Register  to view this content.

[mterrazas]

To get the data validation onto those cells, try:

Please Login or Register  to view this content.

WOW! this worked perfecly! tank you so much!

[daboho]

Ok thank.jefry for suggestion

[Bernie Deitrick]

tank you so much!

And nozzles to you - sorry, an old engineering joke from my days as a petrochemical engineer (we used 'tanks' instead of 'thanks', and 'nozzles' instead of 'no problems'...)