Blank rows in-between rows that are imported from one sheets based on conditions being met

[FinchHRoot]

I have a script that goes through the three ranges on a sheet that is a master list of all transactions/order histories.

Please Login or Register  to view this content.

When the conditions are met, I want the script to copy those cell values to a specific sheet and add them to that sheet in order with out any spaces between

Currently, the script works perfectly besides if the conditions aren't met then it skips a row, i am looking for how to have no empty rows between the copied data.

Screen Shot 2018-12-10 at 11.20.06 AM.png

Thank you for any help in advance

[davesexcel]

Count the rows before you send the data there.

Please Login or Register  to view this content.

[FinchHRoot]

I will give that a try, thank you!!

[jeffreybrown]

Administrative Note:

• We would love to continue to help you with your query, but first, before we can proceed
• Please see Forum Rule #3 about Cross Posting and adjust accordingly.
• Also, please read A message to forum cross posters

[FinchHRoot]

Im getting a compile error, Else without IF

[davesexcel]

Edited code