I was not clear in my description of the original job. The original job description was:
I have an online business. My supplier gives me an excel sheet with data and prices every month.I edit the sheet to show only the products I carry. The next month the supplier gives me a complete sheet again with price updates, availability etc. I need a way to update my master sheet (which has been edited to show only products I carry) with any new price info from the new sheet that I receive every month.
I would like to amend it to include:
I would like the master sheet automated so I can do the work myself every month. I am guessing I will need the master sheet set up with a macro or script.