Before I go into any detail I want to post a high-level summary of what I am attempting to achieve to see if it can be achieved.
OVERALL
On the worksheet labeled "TABLE", I have a table of part numbers(column A) that relate with each of my locations (account numbers) Columns B through P. Each day I receive a list of parts (part numbers) currently available for any of my locations. I will paste that list into the "tblAVAILABLEITEMS" worksheet. My objective is to determine which locations could use those available parts. It’s a “one to many” type relationship whereas each part number might relate to as few as “0” account numbers and as many as “15” account numbers. I am trying to figure out a way of searching the daily list of available parts (part numbers) and display which, if any, of the account numbers are associated each available part.
I thought it best to get this posted before I go too far down the road any maybe need to redesign.
OVERALL
On the worksheet labeled "TABLE", I have a table of part numbers(column A) that relate with each of my locations (account numbers) Columns B through P. Each day I receive a list of parts (part numbers) currently available for any of my locations. I will paste that list into the "tblAVAILABLEITEMS" worksheet. My objective is to determine which locations could use those available parts. It’s a “one to many” type relationship whereas each part number might relate to as few as “0” account numbers and as many as “15” account numbers. I am trying to figure out a way of searching the daily list of available parts (part numbers) and display which, if any, of the account numbers are associated each available part.
I thought it best to get this posted before I go too far down the road any maybe need to redesign.
