Forum Discussion

FerretMom95's avatar
FerretMom95
Copper Contributor
Oct 23, 2024

Tool to check table against 2 other tables in excel

Hi all,

I am working on project that checks on stock levels when next daya delivery list is copied in.

Company has a SQL server that has all stock information. I have pulled data into excel so now I have a table (Stock list) that contains stock id and quantity how many is in the storage. 

User would daily have a list of new stock items that will be delivered next day. I need to check it against Stock list and display quality in the storage.

Stock list table contains more than 400000 rows.

 

No RepliesBe the first to reply

Resources