Loop and combine multiple columns

[Petter120]

Hi!

I need help with a loop like this:

1. loos trough range A1:A10 and copy all cells that contains a value (text or numeric) to Column D from first row down.
2. loop trough range B1:B10 and copy all cells that contains a value (text or numeric) to Column D from lastrow that contains data.

Sample workbook: excelforum.xlsx

Best regards

Petter

[ARowbot]

Try this

Please Login or Register  to view this content.

[AB33]

Try the attached.

[Petter120]

Thanks both of you, it works perfect