Hi Guys,
I've some basic understanding of Macros and VB but this is too complex for me so I'm hoping one of the kind souls here can help me with a solution.
I've got a workbook with multiple worksheets that tracks our Vendors for each company, there are 5 Worksheets in total, each for a different division in our group.
Some of the vendors are duplicates, some are unique. Each worksheet is setup the same way, 2 columns, starting at Row 12, column A is the Vendor Code for that division IE: GRE001 and Column B is the vendor name, IE: Gregg's distributors.
What I'm trying to do is create one master list (that can update automatically/manually)
This master list would contain the Vendor names down Column A, without duplicates. In columns B - F we would populate the Vendor Code for that division, only IF that division had an account with that Vendor. Thus, at a glance, the master list tells me which companies in TOTAL we have accounts with and which division(s) have purchasing power at that vendor.
Does this seem possible?
Any help is appreciated.
I've some basic understanding of Macros and VB but this is too complex for me so I'm hoping one of the kind souls here can help me with a solution.
I've got a workbook with multiple worksheets that tracks our Vendors for each company, there are 5 Worksheets in total, each for a different division in our group.
Some of the vendors are duplicates, some are unique. Each worksheet is setup the same way, 2 columns, starting at Row 12, column A is the Vendor Code for that division IE: GRE001 and Column B is the vendor name, IE: Gregg's distributors.
What I'm trying to do is create one master list (that can update automatically/manually)
This master list would contain the Vendor names down Column A, without duplicates. In columns B - F we would populate the Vendor Code for that division, only IF that division had an account with that Vendor. Thus, at a glance, the master list tells me which companies in TOTAL we have accounts with and which division(s) have purchasing power at that vendor.
Does this seem possible?
Any help is appreciated.