I have a worksheet which has Order designed on it with Combo Boxes for Supplier and Item information which are named ranges in Supplier tab and Item tab used in listfillrange property in Combo Box with Linked cell property referencing cell B11 and G11 on PO tab. When changes are made to any of the cells linked to the I need the change event to update the relevant source tab (font red) and add system date to changed row in first available blank column on tab. I the item does not exist on tab use ADD event to add item to bottom source sheet with date added.

I have added my workbook it is pretty self explanatory.

ThanksPurcahaseOrderTemplateTestAddNEW.xlsm

carlliebenberg