Hi Guys,

I have a sheet called "Supplier List" which is updated whenever i add a supplier to my "Orders" sheet. It is updated for an individual supplier by the macro at the bottom.
The Orders sheet contains multiple instances of the supplier name and has about 300 row entries.
The Supplier list has a single instance of the Suppliers we have written orders for. The issue is it doesn't stay up to date. Two things happen we either forget to add the supplier to the list or we have to change a supplier on the order and forget to delete them from the "SupplierList" sheet.

The idea is to place a button on the supplier sheet with a macro to carry out an overall update:

STAGE 1 - Add new suppliers to the list

Copy the name of the Supplier from sheet "Orders" table "Table8" col "Supplier" to "Supplier List" table "Table20" col "Supplier"
The name of the supplier should only be copied across if it doesn't already exist in sheet "Supplier List" table "Table20" col "Supplier"
The name needs to be inserted into the next empty row of "Table20". The table has a total row at the bottom.
"Table20" should then be sorted alphabetically by column "Supplier"
The code at the bottom works for the suppliers name in the current cell selected, however we need it to loop through all the names on "Orders" table "Table8" col "Supplier"


STAGE 2 - Delete suppliers from the list
Delete the entire row to the table on sheet "Supplier List" table "Table20" when the supplier no longer exists on "Orders" table "Table8" col "Supplier"

This is the code which we use to copy one supplier at a time.
Please Login or Register  to view this content.
Thanks in Advance
Brett