Hi,

I'm looking for vba which would look from cell A5 downwards for any information (anything not blank). For every row that has data I want the vba to copy particular columns from that row.

Ie. Cell A5 has data = copy cell A5,B5,E5,H5

continue until last row with data and the clipboard should contain all neccesary copied cells.

This data would then be manually pasted elsewhere.

Is this possible?

Thanks!