AUTOMATIC SEND MAIL ON GOOGLE SHEET

HLLO FRIENDS THIS IS SCRIPT COADING FOR SENDING AUTOMATIC MAIL BY GOOGLE SHEET 

Email id  message

/**

 * Sends emails with data from the current spreadsheet.

 */

function sendEmails() {

  var sheet = SpreadsheetApp.getActiveSheet();

  var startRow = 2; // First row of data to process

  var numRows = 2; // Number of rows to process

  // Fetch the range of cells A2:B3

  var dataRange = sheet.getRange(startRow, 1, numRows, 2);

  // Fetch values for each row in the Range.

  var data = dataRange.getValues();

  for (var i in data) {

    var row = data[i];

    var emailAddress = row[0]; // First column

    var message = row[1]; // Second column

    var subject = 'Sending emails from a Spreadsheet';

    MailApp.sendEmail(emailAddress, subject, message);

  }

}

AUTOMATIC LOCK CELL AFTER ENTER TEXT IN CELL VBA COADING

HI FREND WITH THIS CODE WE CAN USE AUTOMATIC LOCK CELL AFTER ENTER TEXT IN CELL

Sub Worksheet_Change(ByVal Target As Range)

Dim xRg As Range

On Error Resume Next

Set xRg = Intersect(Range("A1:E15"), Target)

If xRg Is Nothing Then Exit Sub

Target.Worksheet.Unprotect Password:="111"

xRg.Locked = True

Target.Worksheet.Protect Password:="111"

End Sub

EXCEL VB COADING AND FORMULAS

THIS IS BASIC COADING  FOR APPLY AUTOMATIC FILTER IN EXCEL SHEET 

 Advancefilter.applyfilter

AGAR KISI CELL ME TEXT AUR NUMBER EK  SATH AUR ISE ALAG KARNA CHAHTE HE TO 

THIS FORMULA APPPLY IS FORMULE SE NUMBER ALAG HO JAYEGA

=RIGHT(L823,LEN(L823)-MIN(FIND({0,1,2,3,4,5,6,7,8,9},L823&"0123456789"))+1)

AND IS FORMULE SE TEXT ALAG HO JAYEGA

=LEFT(L824,MIN(FIND({0,1,2,3,4,5,6,7,8,9},L824&"0123456789"))-1)

GMAIL SUITE ACCOUNT TRAININF

THIS IS LINK FOR ADVANCE TRAINING OF GMAIL SUITE ACCOUNT

 [03/10, 5:57 PM] Aakash: https://youtu.be/A

[03/10, 5:58 PM] Aakash: https://youtu.be/q9XdDViKXE4

[03/10, 5:58 PM] Aakash: https://youtu.be/ib1j8B-rz6k

[03/10, 5:58 PM] Aakash: https://youtu.be/t42XCAChUN

[03/10, 5:59 PM] Aakash: https://youtu.be/jTageuhPfAM

[03/10, 5:59 PM] Aakash: https://youtu.be/Y7g8vWv11Vk

[03/10, 5:59 PM] Aakash: https://youtu.be/JENOhSXzi2U

[03/10, 6:00 PM] Aakash: https://youtu.be/yl_YoF7W4nQ

[03/10, 6:00 PM] Aakash: https://youtu.be/bDg1u6sZ1Aw

[03/10, 6:00 PM] Aakash: https://youtu.be/hBekKtV8Hr0

[03/10, 6:01 PM] Aakash: https://youtu.be/hI91Sb50OhI

[03/10, 6:01 PM] Aakash: https://youtu.be/1-CJpgofhCs

[03/10, 6:01 PM] Aakash: https://youtu.be/hJdoMKYjQDc

[03/10, 6:01 PM] Aakash: https://youtu.be/DgmP2puTXNA

[03/10, 6:02 PM] Aakash: https://youtu.be/KHzYMGNEKmA

[03/10, 6:02 PM] Aakash: https://youtu.be/FNRHSq58vpk

[03/10, 6:02 PM] Aakash: https://youtu.be/xFY9hGicTRM

[03/10, 6:03 PM] Aakash: https://youtu.be/7hv67zTj5sw

[03/10, 6:03 PM] Aakash: https://youtu.be/pesssXLkBsQ

[03/10, 6:03 PM] Aakash: https://youtu.be/_GcG4FuB-F8

[03/10, 6:03 PM] Aakash: https://youtu.be/mAcJvUeKoDY

[03/10, 6:03 PM] Aakash: https://youtu.be/brbyNmcJtII

[03/10, 6:03 PM] Aakash: https://youtu.be/YEbBB3gD_Pk

[03/10, 6:04 PM] Aakash: https://youtu.be/5i78mmbwwIA

[03/10, 6:04 PM] Aakash: https://youtu.be/45AOSKa9O08

GSUITE ACCOUNT LINK

ALL IS LINK OF GSUITE ACCOUNT

https://youtu.be/GdYq78dYG3k https://youtu.be/FmJLm_WJx8M [02/10, 15:52] Akash: https://youtu.be/d9DnXuSGF1o [02/10, 15:52] Akash: https://youtu.be/zbM4YIO8dhA [02/10, 15:52] Akash: https://youtu.be/wo4WXEIeP_o [02/10, 15:52] Akash: https://youtu.be/L42qB9xw92M [02/10, 15:52] Akash: https://youtu.be/0Ecu-9auVS0 [02/10, 15:52] Akash: https://youtu.be/9rGzdAeo9J8 [02/10, 15:52] Akash: https://youtu.be/0QUI7P9iU0g [02/10, 15:52] Akash: https://youtu.be/A2bx9vOaeBI [02/10, 15:52] Akash: https://youtu.be/CUTtwqgtF4s [02/10, 15:52] Akash: https://youtu.be/QLJ22YHo4AU [02/10, 15:52] Akash: https://youtu.be/P-Ek_J4h5eE [02/10, 15:52] Akash: https://youtu.be/NhAkVxsBXdk [02/10, 15:52] Akash: https://youtu.be/ystdF6jN7hc [02/10, 15:52] Akash: https://youtu.be/8GUB41-zjUo [02/10, 15:52] Akash: https://youtu.be/gT0VUKx-DWw [02/10, 15:52] Akash: 2 day [02/10, 15:52] Akash: https://youtu.be/1nInGoFsT3w [02/10, 15:52] Akash: https://youtu.be/BQVhT_9YDes [02/10, 15:52] Akash: https://youtu.be/PJqWGcc48EQ [02/10, 15:52] Akash: https://youtu.be/mGtf39d8u3w [02/10, 15:52] Akash: https://youtu.be/R1tujSAk-zY [02/10, 15:52] Akash: https://youtu.be/32qbHtZvZtM [02/10, 15:52] Akash: https://youtu.be/Y9FOyoS3Fag [02/10, 15:52] Akash: 3 [02/10, 15:52] Akash: https://youtu.be/uP09aFXQ58E [02/10, 15:52] Akash: https://youtu.be/vS4DAW_dJdI [02/10, 15:52] Akash: https://youtu.be/mlfWKYvGxt0 [02/10, 15:52] Akash: https://youtu.be/2HsFRKoPUQU [02/10, 15:52] Akash: https://youtu.be/dojB4fT27VQ [02/10, 15:53] Akash: https://youtu.be/G-ZMQi63PZA [02/10, 15:53] Akash: https://youtu.be/ul4PguzpCOY [02/10, 15:53] Akash: https://youtu.be/wwhT48edwgQ [02/10, 15:53] Akash: https://youtu.be/9TiXR5wwqPs [02/10, 15:53] Akash: https://youtu.be/1Uy-3l28N1I [02/10, 15:53] Akash: https://youtu.be/-3sW5UCarRE [02/10, 15:53] Akash: https://youtu.be/_Xqfc9rOlvI [02/10, 15:53] Akash: https://youtu.be/PHs7x08PgKQ [02/10, 15:53] Akash: https://youtu.be/Pdp8djigJG8 [02/10, 15:53] Akash: https://youtu.be/7W2-Q0gjTVk [02/10, 15:53] Akash: https://youtu.be/clk6kNBArUs [02/10, 15:53] Akash: https://youtu.be/2hUUaG4o3DA [02/10, 15:53] Akash: https://youtu.be/JHxU4DCjXV0 [02/10, 15:53] Akash: https://youtu.be/d9L-au66Zmw

[03/10, 5:57 PM] Aakash: https://youtu.be/zXPs3HtJjSk

[03/10, 5:58 PM] Aakash: https://youtu.be/q9XdDViKXE4

[03/10, 5:58 PM] Aakash: https://youtu.be/ib1j8B-rz6k

[03/10, 5:58 PM] Aakash: https://youtu.be/t42XCAChUN8

[03/10, 5:59 PM] Aakash: https://youtu.be/jTageuhPfAM

[03/10, 5:59 PM] Aakash: https://youtu.be/Y7g8vWv11Vk

[03/10, 5:59 PM] Aakash: https://youtu.be/JENOhSXzi2U

[03/10, 6:00 PM] Aakash: https://youtu.be/yl_YoF7W4nQ

[03/10, 6:00 PM] Aakash: https://youtu.be/bDg1u6sZ1Aw

[03/10, 6:00 PM] Aakash: https://youtu.be/hBekKtV8Hr0

[03/10, 6:01 PM] Aakash: https://youtu.be/hI91Sb50OhI

[03/10, 6:01 PM] Aakash: https://youtu.be/1-CJpgofhCs

[03/10, 6:01 PM] Aakash: https://youtu.be/hJdoMKYjQDc

[03/10, 6:01 PM] Aakash: https://youtu.be/DgmP2puTXNA

[03/10, 6:02 PM] Aakash: https://youtu.be/KHzYMGNEKmA

[03/10, 6:02 PM] Aakash: https://youtu.be/FNRHSq58vpk

[03/10, 6:02 PM] Aakash: https://youtu.be/xFY9hGicTRM

[03/10, 6:03 PM] Aakash: https://youtu.be/7hv67zTj5sw

[03/10, 6:03 PM] Aakash: https://youtu.be/pesssXLkBsQ

[03/10, 6:03 PM] Aakash: https://youtu.be/_GcG4FuB-F8

[03/10, 6:03 PM] Aakash: https://youtu.be/mAcJvUeKoDY

[03/10, 6:03 PM] Aakash: https://youtu.be/brbyNmcJtII

[03/10, 6:03 PM] Aakash: https://youtu.be/YEbBB3gD_Pk

[03/10, 6:04 PM] Aakash: https://youtu.be/5i78mmbwwIA

[03/10, 6:04 PM] Aakash: https://youtu.be/45AOSKa9O08

ADVANCE FORMULE OF GOOGLE SHEET

ADVANCE FORMULE  OF GOOGLE SHEET 

'=ARRAYFORMULA(if(Row(A:A)=1,"Duplicate Check",if(C:C="","",if(countif(C:C,C:C)>1,"Duplicate",""))))

=ARRAYFORMULA(if(Row(A:A)=1,"Check for Duplicates",If(B:B="","",if(countif(B:B,B:B)>1,"Duplicate",iferror(if(match(B:B,blist,0),"Bounced","NA"))))))

=ARRAYFORMULA(if(Row(A:A)=1,"Send NL #",if(C:C="","",VLOOKUP(C:C,schedule,3,false))))

=ARRAYFORMULA(if(Row(A:A)=1,"Sched Date",if(C:C="","",VLOOKUP(C:C,schedule,5,false))))

="Pending to Sched: "&counta(B3:B)-counta(C3:C)

=ARRAYFORMULA(if(Row(A:A)=1,"Send Tmpl #",if(C:C="","",if(D:D="","NA",if(D:D=0,0,if(VLOOKUP(D:D,scheduled,3,false)="","NA",VLOOKUP(D:D,scheduled,3,false)))))))

=if(E9=today(),match(E9,F9:BA9,0),"")

'=if(OR(A3="",sum(F3:BA3)=0),"", iferror(min(filter(F3:BA3,F3:BA3>=today()))))

  =if(P149="","",image(concatenate("http://drive.google.com/uc?export=view&id=",index(split(P149,"="),0,2))))

=IF(T150,T150,IF(U150="yes",NOW(),""))

=IF(COUNTIF(E9:E19,E9)>1,E9,"")

 =IF(VALUE(RIGHT(G13,1))=0,"",1)

 =LARGE(J6:J12,{1,2,3})

 =SMALL(J6:J12,{1,2,3})

EXCEL ME FORMAT CELL KE ANDAR CUSTOM OPTION KA USE

EXCEL ME CUSTOM FORMATING KA USE KARNA AJ SIKHEGE TO YE OPTION CUSTOM FORMATING KA HAI JISKI SHORT CUT CTRL+1 HAI YE FORMAT CELL BOX OPEN HO GAYA

DOSTO CUSTOM OPTION KA USE EK ADVANCE TARAH SE KYA JATA HAI ISME HUM CONDITION DEKE USE KAR SAKTE HAI AIYE KUCH USE DEKH LETE HAI

IS TARAH SE CONDITION DEKE SHOW KARWA SAKTE HAI  IS TARAH KA ISKA USE KYA JATA HAI

AUR YE RAHI COADING

[Red][<50]"PASS";[Black][<90]"FIRST";[Green]"FAILs"

AGAR AP CHAHO TO KISI BHI NUMBER KE BAD KOI UNIT YA PAHLE KOI UNIT AUTOMATIC LAGANA CHAHTE HO TO

EXAMPLE  :- GENERAL "KG"

YE CODING DALNE PAR SABHI KE SATH KG AYEGA  AGAR AP CHATE TOTAL NUMBER APKE HISAB SE HONE CHAHYE YA SHURU ME ZERO ANA CHAHIYE TO CUSTOM ME JAKAR UTNE ZERO TYPE KARKE OPEN KAR DO FR ZERO SHOW KAREGA IS TARAH SE

OK BYE DOSTO