Hi there,
I need assistance.
I need a macro that will return a formula.
For instance
I need to count how many (a) b and (c) there are.
If I have the following vallue in the following cell
A1 = A Balance
A6 = A General
A7 - B Balance
A8 = B Balance
A9 = C General
A10 = A Balance
A11 = B General
A12 = C General
A13 = B Balance
A14 = C Balance
A15 = B Turn
A17 = B Turn
A19 = C Jump
A20 = A Turn
The outcome of this macro should then be in the form of a message box:
Tricks: (1A General, 2A Balance) A's formula should also be place in B55
(1B General, 2B Balance); B's Formula should also be placed in E55
(2C General,1C Balance) C's Formula should also be place in H55
Turns: ( 1A Turn) (2B Turns) A's forumula for turns should be place in B56 and B's Turn should be place in E56
Jumps: (1C Jump)
Basically it needs to count how many A General, A Balalance; B General, B Balance; C General, C Balance, A Turns, A Jumps; B Turns, B Jumps; C Turns, C Jumps there is and apply it the cells mentioned above.
Hope someone can help me with this
I need assistance.
I need a macro that will return a formula.
For instance
I need to count how many (a) b and (c) there are.
If I have the following vallue in the following cell
A1 = A Balance
A6 = A General
A7 - B Balance
A8 = B Balance
A9 = C General
A10 = A Balance
A11 = B General
A12 = C General
A13 = B Balance
A14 = C Balance
A15 = B Turn
A17 = B Turn
A19 = C Jump
A20 = A Turn
The outcome of this macro should then be in the form of a message box:
Tricks: (1A General, 2A Balance) A's formula should also be place in B55
(1B General, 2B Balance); B's Formula should also be placed in E55
(2C General,1C Balance) C's Formula should also be place in H55
Turns: ( 1A Turn) (2B Turns) A's forumula for turns should be place in B56 and B's Turn should be place in E56
Jumps: (1C Jump)
Basically it needs to count how many A General, A Balalance; B General, B Balance; C General, C Balance, A Turns, A Jumps; B Turns, B Jumps; C Turns, C Jumps there is and apply it the cells mentioned above.
Hope someone can help me with this