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.
 

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.

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
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,160
Messages
5,835,725
Members
430,383
Latest member
Kastore

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