Paste special values from one worksheet into next blank row in another

[AngelaG]

Think my coding complies now:-)

Hi All,
Totally new to VBA but I need my macro button to paste special the values from one data selection in one worksheet (cells L7:N7), into the next available blank row in a separate worksheet (columns B:E).

I've got thus far with the below code but obviously this just copies and pastes into the same fields as oppose to the next blank row.

Help would be massively appreciated: :-)

Angela

Please Login or Register  to view this content.

[teylyn]

Angela,

go back to your first thread, edit the question and apply the code tags there instead of posting a duplicate.

thanks,