script that will run depending on how many cells have a value

[SIPRIAN]

Hi,

I have a query and a macro that runs on Sheet1 and I would like to have a script in Sheet2 that will run when I click on the button that i created, depending on how many cells in A7 to A14 have a value. The values that are in Sheet2 cell A7 to A14 are copied with formula from Sheet1

If cell A7 has a value and a8 to A14 don't have a value, Macro1 should run.
If cell A7 and A8 have a value and A9 to A14 don't have a value, Macro2 should run should run.
If cell A7 A8 and A9 have a value and A10 to A14 don't have,Macro3 should run should run.
If cell A7 A8 a9 and A10 have a value and A11 to A14 don't have, Macro4 should run......and so on


Thank you!