Hi,
Sheet : Section_14
<tbody>
</tbody>Sheet : Section_6
<tbody>
</tbody>Hi i was trying to write a vba code that would lookup up in the column "Service" if the value was "BlackBerry usage", if yes copy the "GSM number" into a new sheet called "BlackBerry".
And then using this number copy the "Account Number" in the sheet Section_6 to "BlackBerry" in column B.
Sheet : Section_14
Month | GSM number | Group name | Subgroup name | Name GSM number | User ref1 | User Ref2 | Call date | Call time | Total volume (KB) | Service | Zone/Country/Operator | Tariff | Type | Supplementary services | Usage amount | Currency | Account number | Discount Indicator |
Jan-13 | 0470/132024 | Unfiled - Niet toegekend - Non attribué | 18-Dec-12 | 15:48:58 | 893 | Mobile Internet | Réduit | GPRS national | 0 | EUR | 10736059 | N | ||||||
Jan-13 | 0470/132024 | Unfiled - Niet toegekend - Non attribué | 22-Dec-12 | 11:32:23 | 313 | Mobile Internet | Réduit | GPRS national | 0 | EUR | 10736059 | N | ||||||
Jan-13 | 0470/132024 | Unfiled - Niet toegekend - Non attribué | 19-Dec-12 | 03:47:57 | 2368 | Mobile Internet | Réduit | GPRS national | 0 | EUR | 10736059 | N |
<tbody>
</tbody>
GSM number | Group name | Subgroup name | Name GSM number | User ref1 | User Ref2 | IMEI | SIM Card Number | Handset Brand | Handset Type | Account number |
0470/132024 | Unfiled - Niet toegekend - Non attribué | 1.27E+13 | 2.10E+12 | Apple | iPhone 4 | 10736059 | ||||
0470/200128 | Unfiled - Niet toegekend - Non attribué | 3.54E+14 | 2.10E+12 | 25054440 | ||||||
0470/201029 | Unfiled - Niet toegekend - Non attribué | 3.54E+14 | 2.10E+12 | 25056030 |
<tbody>
</tbody>
And then using this number copy the "Account Number" in the sheet Section_6 to "BlackBerry" in column B.