I have an issue in which I need to copy any column between "V and AD" in which the cell in row 104 is greater than 0. So if only z104 equals 45 I need column Z to be copied then transposed into workbook "PC OPP.xlsm" Sheet "trade Blotter" in the next empty row. Any one have any Ideas?