VBA to calculate from two tables

[shah0101]

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.

 

[Marc L]

Hi,​

​

as you already received help for the same subject on another forum …​

​

And according to forum rules - whatever the Excel forum - you must share a link for each thread on the same subject on every other forums.​

​

 

[macropod]

shah0101: Please read Chandoo's policy on Cross-Posting in the forum rules :

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...

chandoo.org