VBA code, Named range as Rowsource need to offset -1 column

Hi all. New to VBA. I have a userform with comboboxes. The first combobox has a rowsource assigned through properties, on selection it runs an advanced filter. I have named a range from the extraction "WIPHeader" to polulate a second combobox which on selection from this populates some textboxes successfully, however, one of these textboxes calls for data outside of the named range. i.e. the named range is columns G to K, however the data for this textbox is in column F of the extraction from the advance filter. Is it possible to offset the named range back one column? The below column(-1) doesn't work.

Please Login or Register  to view this content.

Second combobox:

Please Login or Register  to view this content.

Populates textboxes - WIP7 refers to supplier details which is outside the named range "WIPHeader"

Please Login or Register  to view this content.

I'm unable to post the workbook at this time as I'm too far into the project with sensitive data.
Any help would be appreciated.

Hi, thank you for taking the time to read my post. I will investigate your suggestion. I'm wondering however, as the second combobox which runs an advance filter that populates the other textboxes, would using list correlate to the data for the selected row in the extract data from this advance filter ? Hope this makes sense.