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

tuytuy

Board Regular
Joined
Mar 28, 2013
Messages
75
Hi,

Sheet : Section_14
MonthGSM numberGroup nameSubgroup nameName GSM numberUser ref1User Ref2Call dateCall timeTotal volume (KB)ServiceZone/Country/OperatorTariffTypeSupplementary servicesUsage amountCurrencyAccount numberDiscount Indicator
Jan-130470/132024Unfiled - Niet toegekend - Non attribué18-Dec-1215:48:58893Mobile InternetRéduitGPRS national0EUR10736059N
Jan-130470/132024Unfiled - Niet toegekend - Non attribué22-Dec-1211:32:23313Mobile InternetRéduitGPRS national0EUR10736059N
Jan-130470/132024Unfiled - Niet toegekend - Non attribué19-Dec-1203:47:572368Mobile InternetRéduitGPRS national0EUR10736059N

<tbody>
</tbody>
Sheet : Section_6
GSM numberGroup nameSubgroup nameName GSM numberUser ref1User Ref2IMEISIM Card NumberHandset BrandHandset TypeAccount number
0470/132024Unfiled - Niet toegekend - Non attribué1.27E+132.10E+12AppleiPhone 410736059
0470/200128Unfiled - Niet toegekend - Non attribué3.54E+142.10E+1225054440
0470/201029Unfiled - Niet toegekend - Non attribué3.54E+142.10E+1225056030

<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.
 

Some videos you may like

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

patel45

Well-known Member
Joined
Jul 15, 2012
Messages
1,953
please upload a small sample file on a share site then paste the link here, including desired result
 

Watch MrExcel Video

Forum statistics

Threads
1,122,216
Messages
5,594,886
Members
413,947
Latest member
gizmolucy

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top