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.
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. Read More