Can anyone help
I have a work sheet with data and I copy the data from one sheet to another in different cells, all the data from cells D8,9,10,11,12 & E8,9,10,11,12 go into the travel sheet all works good
But the problem I have if there is only data in cell D8 it puts the data in the travel form in the correct cell but the data is at the top of the cell and not in the middle, as it is copying all the balnk cells too.
Can I do at if fuction ie if Blank do nothing?
Here is the code if anyone can help