Copy cell value to another worksheet and move down 1 row each time its pressed.

[danbates]

Hi,

Please could someone help me?

I found this password creator and I would like to edit it so when I press the create password button it copies the cell value in N11 (Password) to cell I5 (Sheet1) but when I press it a second time I want the cell value in N11 to move down 1 cell to I6 (Sheet1) and so on and so on.

I hope this makes sense and any help would be much appreciated.

Kind Regards
Dan

[danbates]

Hi,

Don't worry about this thread now I've managed to sort it.

Thanks

Dan