VBA If Cell = X, Then Copy Some Columns Into A New Sheet

[tuytuy]

Hi,

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

<colgroup><col><col><col span="2"><col><col span="2"><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>

Sheet : Section_6

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

<colgroup><col><col span="2"><col><col span="2"><col><col><col><col><col></colgroup><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.

 

[tuytuy]

so sorry i posted it 3 Times !

 

[Scott Huish]

Duplicate post. See http://www.mrexcel.com/forum/excel-...-=-x-then-copy-some-cells-into-new-sheet.html