Continuing Excel Data in another adjacent column

[Elflord]

I don't do things by halves so here is a notty problem I have and cannot resolve

I am picking up data from a sale sheet and where the vendor number matches the vendor in the sale sheet I am returning the lot, description and Sale value. Now when I get to the bottom of my "form" which is about 30 lines long, I want to continue the items that have been sold on behalf of the vendor but starting at column F as shown below

Please can you tell me if this is at all possible?

Many thanks

 

[Smitty]

Welcome to the Board!

You can't link to an image on your pc; you'll need to post it to an image hosting site, then post the url.