Lookup code

Hi

Please could someone please help me with the following:

I have two tables, table 1 is empty and needs data transfered from table 2
(I have attached an example for reference)

the data in table two is variable and changes dependant on other options selected within the workbook.

The thing I cant work out is how after completing the A column (in table 1) how I can get the B column to miss the rows that are adjacent to any completed rows in the A column and put the values in the next 'clear' rows.

My 2 examples attached, I completed manually to give an Idea of what i need.

Any help is as always much appreciated.

Thanks in advance.

This seems to work for your top table (assuming the size doesn't change?)

Please Login or Register  to view this content.

This is awesome, thank you so much for this!