VBA code that will extract data from two databases and will revert a single value

[Tanisha33]

Hi,
I need an VBA code that will do the following:
- search from Database 2 for all products, based on the 6 digits code from the products title (line 1), in Database 1.
- if the product (based on the 6 digits code) exists in Database 1, and if "Cal" column equal "15" - should multiply his corresponding value from Database 2, line 2 (Sales) with his Price (column C) from database 1, and afterwards do their sum, which will be divided to the sum of their Prices. The result should be showed in percentage.

The result should be: 14,67%
Thank you!