Excel Macro

Closed
Report
Posts
1
Registration date
Tuesday November 10, 2015
Status
Member
Last seen
November 10, 2015
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Why this question looks like exam or a quiz
0