.

 https://medicatusb.com/

 

 https://www.javatpoint.com/

Source  https://www.exceltrainingvideos.com/search-multiple-values-in-worksheet-data/ Search Multiple Values in Worksheet Data How to search multiple values in worksheet data using VBA. Earlier we had learnt how to  search for data in a worksheet  using a looping process but were able to find a single value. Today we learn to extract all the occurrences of data in our worksheet like an item code with VBA. Watch the video below: Here’s the complete VBA code to find multiple data withe the same value: Sub searchMultipleValues() Dim erow As Long Dim ws As Worksheet Dim lastrow As Long Dim count As Integer lastrow = Sheets(“item_price”).Cells(Rows.count, 1).End(xlUp).Row Sheet2.Range(“a11:C1000”).ClearContents count = 0 Dim p As Long p = 11 For x = 2 To lastrow If Sheets(“item_price”).Cells(x, 1) = Sheet2.Range(“b3”) Then Sheet2.Cells(p, 1) = Sheets(“item_price”).Cells(x, 1) Sheet2.Cells(p, 2) = Sheets(“item_price”).Cells(x, 2) Sheet2.Cells(p, 3) = She...

NTC USSD Codes, SMS Codes and IVR TECH By News Team On Jan 1, 2018 Share A USSD code is entered into phones to perform actions. They are mainly used by network operators to provide customers with easy access to pre-configured services, including call-forwarding, balance inquiries and multiple SIM functions. USSD stands for  U nstructured S upplementary S ervice D ata. Below you will find some of the important USSD codes to be used on NTC Network to inquire and subscribe to various services offered by the telecom operator. 1 Find your NTC Phone number (Know your mobile no) *9# Output  :  MSISDN : 977********** Your Number 2 Balance Check (Main account balance check code) *400# Output : Your Balance is Rs.XX,Expiry Date is 2019-02-25. 3 Recharge – Topup Balance *411#Scratch Card Pin # 4 Customer Service (IVR) Dial 1415 – Balance Inquiry(Credit Limit) -Recharge -Complain -Other S...