vba code to extract data from data table and update data sheet

Originally Posted by leelnich

Hi JeanCould you please clarify: is this data coming from 'Table 1'!column D, or from 'Table 1'!column N? Both have a value of 15.

Hi Leelnich

time difference , it was late night on my side.

So to clarify the data come from table1 , so if there is sadc on data sheet column K2 then it stands y (yes) otherwise if k3 is blank then it puts 15 according to column tariff no column I of data sheet which is related to table 1 ff tariff column A.
I reupload the file there was error on my side on data sheet