Hi,
I have a workbook with few tabs "Product A", "Product B", Product C"..etc, in each worksheet, there're few columns, ie "Vendor", "Country", "Invoice#',"Discount", "Invoice date". The data will be updated daily.
I need to build a lookup function in another workbook.
Selection by Vendor, Country and invoice#, then after "Look up" button is clicked, it will automatically list down those related data with latest invoice date and the price after calculation.
How can it be done?
Do I need Macro? I only know the basic excel function.
If the selection is in combo box, how can I reference it to the database worksheet?
Many thanks in advance.
Best Regards,
Veron
I have a workbook with few tabs "Product A", "Product B", Product C"..etc, in each worksheet, there're few columns, ie "Vendor", "Country", "Invoice#',"Discount", "Invoice date". The data will be updated daily.
I need to build a lookup function in another workbook.
Selection by Vendor, Country and invoice#, then after "Look up" button is clicked, it will automatically list down those related data with latest invoice date and the price after calculation.
How can it be done?
Do I need Macro? I only know the basic excel function.
If the selection is in combo box, how can I reference it to the database worksheet?
Many thanks in advance.
Best Regards,
Veron