Form Extractor Issue

[Ravenous]

Hi All,

I have a Macro set up which allows me to extract data from various forms in a folder and paste this data into a single row of a log.
The Macro works great but there is just one problem; I have a cell in my form template for Customer Number which may or may not return a value as some forms do not have a customer number. If this happens and then the next form does have a number then the number will go into the last empty cell of the column because this is how the macro is set up but this means that the number will be in the incorrect row.

In the attached example, Test (5) is returning the Customer Number value for Test (6).

Can anyone please advise on how I can set this up to avoid this problem? My thoughts are to go down on the adjecent column and offset the result to the left but I don't know how to do this.

Appreicate any assistance