Lookup code

[jazzymonkey]

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.

[StephenR]

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

Please Login or Register  to view this content.

[jazzymonkey]

This is awesome, thank you so much for this!