MICROSOFT KE MASTER BANO BY A.K.V: October 2020

Wednesday, October 28, 2020

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

Tuesday, October 13, 2020

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)

Friday, October 9, 2020

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

Friday, October 2, 2020

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