Hi Experts (see attached workbook)
Looking at worksheet Deal Selection column(s) B and I
Range B9:B58 and I9:I58
If the user adds a new supply customer in column B then I would like this to be
Reflected in worksheet Tables column J5 onwards.
And visa versa for column I add to column L5 onwards Tables worksheet
Need this to keep the defined name range table compact and do not wan to see
Empty spaces when I do my data validation later on