There are two files attached. I need the data that is in the PDF file entered into the excel file.
The data in the attached excel file is to be erased and replaced with data from PDF file.
In the "discount", cell B12, should set to a default when file is opened but also changeable by user
I want the SKU column as it is but unlike the attached I would like a keyword search for the SKU as well based on the product description
I also want a way to add items to a SKU. For instance is SKU B12 item 1 and the main SKU the user can add BSV to item 1 and will become item 1.1.
The branding will need to be changed, I will provide that