Hi Katie,

Thanks again for your support.

The limit to your solution is that I don't have the drop down list available anymore in supplier invoice & now in the reference sheet , it's completely the opposite of what I wanted...
As said above, the drop down lists should be in "Supplier Invoice" sheet in P&L 1 & 2 columns.

I would like the P&l 1/2 cells to automatically fill the drop down list entries (given reference sheet) & have the choice to choose the entries for unusual suppliers.
Please let do not hesitate to contact me if you would need more info.