lundi 27 mars 2017

How can I fill whole column based on each of its row datas using IF function?

Table Example

So the "•" is acting like a tick mark. The grey-colored font is the RESULT that I want to have whenever I input a tick mark in whichever column.

For example: 1. If I tick the "B" only, the "Package" (which is in this case is cell F3) will automatically be filled with "Cheapest". 2. If I tick all of the columns: A,B,1,2,3, the "Package" will automatically be filled with "Full Package". 3. and so on.

If possible can someone help me with the VBA Code because my skill in VBA is still not that good and I cannot use manual IF function since it'll be too long.

Thank you in advance!

Aucun commentaire:

Enregistrer un commentaire