Data entry to loop to next row

Hello all,

so I have a table to enter data, seven columns... I have wrote a command button with a inputbox code.

so basicly what I do is.. I click the command button and it asks me to fill the data from cell A2 to G2.

what I need is that after I fill data on G2, I need to repeat the whole process on the next row which means from A3 to G3 and so on.... in other words I need the code to reach column G then go back to column A but in the next row.

here is what I have as a code:

Please Login or Register  to view this content.

P.S im also attaching the worksheet

Thanks

Originally Posted by patel45

for 10 rows

Please Login or Register  to view this content.

This one worked perfect and I thank you for your help. but now I rememberd 2 things:

first I need this process to continue not only for 10 rows

second I need a way to exist the process when I need to. lets say that I am entering data and I want to exist the excel sheet, how can I do that? the command button will keep asking me to enter data.

one more thing how can I change the code so it will start in the next row. lets say i entered 4 rows today then tomorrow I want to enter another rows so I want it when I click the command button to start in the next row. NOT to over write the before ones.


Thanks again for the help

Hi -

Try this one.

Please Login or Register  to view this content.

event

Originally Posted by patel45

very good gode, but ther'is a double End(xlUp) need this change

Please Login or Register  to view this content.

it is intentional, try it with the file provided.see the opp has a tables

event

GREAT Thank you so much. its perfect.

Originally Posted by event21

Hi -

Try this one.

Please Login or Register  to view this content.

event