I'm trying to create a simple macro, its not working and therefore driving me a bit crazy, all i'm aiming to do is:
If the value in the T/F record is set to true in the table 1 (listed below):
<tbody>
</tbody>
I would like only the contact and percentage to be pulled through into table 2 (outlined below) upon activating the macro:
<tbody>
</tbody>
Table 2 resides on a separate worksheet, any help would be very much appreciated!
Let me know if you require further information and i'll elloborate!
Regards
H
If the value in the T/F record is set to true in the table 1 (listed below):
Table 1 | |||||
No.1 | T/F | Phone number | Other random info | Contact | Percentage |
1 | TRUE | 20453534 | fdgeshsh | Random name | 110% |
2 | FALSE | 454354 | eghertgesrg | Random name | 120% |
3 | FALSE | 24532534 | regergrg | Random name | 130% |
4 | TRUE | 2435345 | ergsar | Random name | 140% |
5 | TRUE | 234525 | ergertghrt | Random name | 150% |
6 | FALSE | 425345 | erhwrh | Random name | 160% |
7 | FALSE | 23452345 | erhwrehrth | Random name | 170% |
8 | TRUE | 245254 | htrhgfbgb | Random name | 180% |
9 | FALSE | 356364 | dfbfbf | Random name | 190% |
10 | TRUE | 2452 | efgethgetheth | Random name | 200% |
<tbody>
</tbody>
I would like only the contact and percentage to be pulled through into table 2 (outlined below) upon activating the macro:
Table 2 | ||
No.1 | Contact | Percentage |
1 | ||
2 | ||
3 | ||
4 | ||
5 | ||
6 | ||
7 | ||
8 | ||
9 | ||
10 |
<tbody>
</tbody>
Table 2 resides on a separate worksheet, any help would be very much appreciated!
Let me know if you require further information and i'll elloborate!
Regards
H