I am creating a new form that takes employee expenses. On each line of the
expense form the employee can chose employee paid or company paid from a drop
down list.
What I have done is created an IF query to copy the data to a corresponding
sheet (one titled company paid and the other employee paid), depending on
whether company paid or employee paid was chosen, however the part I can not
work out how to do is to ensure that when the data is copied to the new sheet
that the next available line is used rather than a straight linked cell.

Is there anyway to automatically go to the next available line on each sheet
when the data qualifies rather than having blank lines inbetween when a
straight linking command is used and the IF criteria is satisfied.