Hi everyone,
I'm trying to make a code where I can upload one spreadsheet with a list of items into a database. Essentially, I want to be able to run a report of all the items that are in the new spreadsheet to see if "yes" they are listed in the database or "no" they are not.
For example, I'd have my Database spreadsheet that lists:
Item Customer
A Customer1
B Customer2
C Customer3
D Customer1
A Customer2
I want to be able to upload a spreadsheet with
Item Customer
A Customer1
B Customer2
C Customer1
If it could generate a report of some kind or even a message box that can report back "Yes" or "No" that they exist in the database spreadsheet, that would be awesome. In the above example, the 2 bold ones would come back as yes and the normal would come back as no. If that makes sense?
I'm trying to make a code where I can upload one spreadsheet with a list of items into a database. Essentially, I want to be able to run a report of all the items that are in the new spreadsheet to see if "yes" they are listed in the database or "no" they are not.
For example, I'd have my Database spreadsheet that lists:
Item Customer
A Customer1
B Customer2
C Customer3
D Customer1
A Customer2
I want to be able to upload a spreadsheet with
Item Customer
A Customer1
B Customer2
C Customer1
If it could generate a report of some kind or even a message box that can report back "Yes" or "No" that they exist in the database spreadsheet, that would be awesome. In the above example, the 2 bold ones would come back as yes and the normal would come back as no. If that makes sense?
