Dear Experts,

I have a workbook with two sheet with two different tables.

Table 1 has Invoice Numbers, Invoice Values and LC Numbers (Table Name is "Inv_21")
Table 2 has the LC Numbers and LC Values (Table Name is "LC_21"


Can I request for a script / module to bring up all the Invoice Numbers and Invoice Values from Table "Inv_21" with an automatic populated Drop Down List of any particular LC Number from Table: "LC_21" which matches the LC Number in both Tables. Then total invoice values of collected invoices and deduct those values from the LC Value?

I have deleted / sanitized as much data as I can. Sample workbook can be downloaded from below link:
https://we.tl/t-yJqNUDGdgC



Much Appreciated.



Thanks.

Cross-Posted at:

Module to Calculate from Two Tables
Module to Calculate from Two Tables
VBA to calculate from two tables | Chandoo.org Excel Forums - Become Awesome in Excel
VBA to calculate from two tables | Chandoo.org Excel Forums - Become Awesome in Excel
VBA Script To Calculate the Balance | MrExcel Message Board
VBA Script To Calculate the Balance | MrExcel Message Board

shah0101: For cross-posting etiquette, please read: Excelguru Help Site - A message to forum cross posters

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]