Copy Last Row

[adam2308]

On the attached example sheet, I have a table of data which the user constantly adds to the next available row. Although, when adding data to the next row the data in some of the columns are going to be the same as the row above. So, I want to make it less tedious filling in these columns for new rows.

I have attached a command button to the top of the worksheet which loads a form. The form has a series of checkboxes relating to certain columns in the table to give the user the choice of which columns top copy down and a text to enter how many rows to copy the last row down.

Any idea how to code?

[arlu1201]

So will they enter in the data in a few cells of a particular row and then click the button to fill up the rest of the columns?

[Trebor76]

Hi adam2308,

Try this:

Please Login or Register  to view this content.

HTH

Robert

[adam2308]

Yes Arlu, that is correct. Trebor is on the right track, the only omission in his code is that it only copies down one row. The number of rows that it copies down should be determinded by TextBox1 in the userform. At the moment I can't see any use of this textbox value in CommandButton2 code.

[Trebor76]

See how this goes:

Please Login or Register  to view this content.

Robert

[adam2308]

That's perfect. Thanks Robert!

[Trebor76]

Thanks for letting us know and you're welcome.