Micro to match two cells & fill relative cells

[SHEIKH TALIB]

Hello everyone,I am having a problem with my data I have a product with color(some doesn't have) & I am trying to create a that can fill my related cell automatically,I have done it with array formula but it slows down excel & I have a large range of products & have to enter a large of amount daily.I need a macro which can be run after I enter all my product & color ,and it can fill my sale sheet,the other on my purchase sheet.
can someone help me?

[PCI]

We additional info to understand the need: What do you want the macro to do.
You could send the formula you are presently using.