How to ignore blank cells?

[Adrian Low]

Hi,

I am trying to ignore the blank cell whenever the marco finds it. I need is the output workbook to be copied a blank cell if the Input workbook has one. Instead of this, I am getting the output of values from the input that is in the subsequent cell and everything moves upwards.

https://imgur.com/a/t9Ezs1c

The picture above shows the input and the output file as you can see row "7" there are some blank values but the output instead of copying the blank cells it copy the value in the subsequent row and this makes everything moves upwards.

Thank you,
Adrian

 

[Fluff]

Glad you sorted it & thanks for the feedback