Excel Macro

WPS require an automated process for adding new suppliers into the "Resource Management" workbook. There is data for three new suppliers (Agenda Corporation,

Borough Capital and ICN Agency) in the "New Suppliers" workbook. Currently all three suppliers are combined together in one table. The following is required:

1) Separate the data into 3 individual tables for each supplier using the function "InStr", along with an "If" statement on the "StaffNo" to determine which supplier the resource belongs to


Below is an extract from the excel sheet
________________________________________________

All Suppliers

StaffNo Name Role
BC.40 ACron Nelson Developer
BC.187 ACron Washington Senior Project Manager
BC.112 Adam Hall Senior Tester
IA.52 Adam White Solutions Architect
IA.91 Aida Titus Senior Tester
AC.14 Alan Barnes Senior Developer
BC.16 Albert Anderson Senior Tester
BC.203 Albert Carter Project Analyst
BC.166 Albert Reed Test Lead