Copying value (inc formatting) of multiple cells into a table A based on value of one cell

[jjin]

Hi guys,

see the attached sample worksheet below first for your better understanding of my question.

I tried to use an excel formatting (If function), however, it only copies the cell value not the formatting.

Any help will be greatly appreciated

Cheers,