MICROSOFT KE MASTER BANO BY A.K.V

Thursday, May 18, 2023

Data copy paste on two another sheet with add row in google sheet by script

function copyDataWithinWorkbook() {

var sourceSheetName = "Dashbord"; // Replace with the name of the source sheet

var targetSheetName = "Data"; // Replace with the name of the target sheet

var insertRow = 27; // Specify the row before which the data should be inserted

var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();

var sourceSheet = spreadsheet.getSheetByName(sourceSheetName);

var targetSheet = spreadsheet.getSheetByName(targetSheetName);

if (!sourceSheet) {

Logger.log("Source sheet not found: " + sourceSheetName);

return;

}

if (!targetSheet) {

Logger.log("Target sheet not found: " + targetSheetName);

return;

}

var sourceRange = sourceSheet.getRange("A25:G52");

var targetRange = targetSheet.getRange(insertRow, 1, sourceRange.getNumRows(), sourceRange.getNumColumns());

targetSheet.insertRowsBefore(insertRow, sourceRange.getNumRows());

var sourceValues = sourceRange.getValues();

targetRange.setValues(sourceValues);

Logger.log("Data copied successfully from " + sourceSheetName + " to " + targetSheetName);

}

Wednesday, May 17, 2023

Data copy to paste in googl sheet by app script

function copyDataWithinWorkbook() {

var sourceSheetName = "Dashbord"; // Replace with the name of the source sheet

var targetSheetName = "Data"; // Replace with the name of the target sheet

var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();

var sourceSheet = spreadsheet.getSheetByName(sourceSheetName);

var targetSheet = spreadsheet.getSheetByName(targetSheetName);

var sourceRange = sourceSheet.getRange("A20:F20");

var targetRange = targetSheet.getRange("A2:F2");

targetSheet.insertRowAfter(1); // Insert a row after the 1th row in the source sheet

var sourceValues = sourceRange.getValues();

targetRange.setValues(sourceValues);

Logger.log("Data copied successfully from " + sourceSheetName + " to " + targetSheetName);

}

Tuesday, June 28, 2022

Automatic copy to paste data in excel

Sub hello()

Range("A1:A10").Copy

Range("F1:F10").PasteSpecial xlPasteValues

Application.CutCopyMode = False

Range("A2:A10").Font.ColorIndex = 10

Call test

End Sub

Sub test()

Application.OnTime Now + TimeValue("00:00:10"), "hello"

End Sub

Automatic timer function in excel

[29/06, 10:52] Aakash: Sub hello()

Worksheets("Sheet1").Range("a2:c2").Select

Selection.Cut

lastrow = Worksheets("Sheet1").Cells(Row.Count, 6).End(xlUp).Row

Worksheets("sheet1").Cells(lastrow + 1, 6).Select

ActiveSheet.Paste

Worksheets("Sheet1").Range("a2:c2").Select

Selection.Delete shift:=xlUp

Worksheets("Sheet1").Range("a2").Select

Call test

End Sub

Sub test()

Application.OnTime Now + TimeValue("00:00:10"), "hello"

End Sub

this code insert ur working sheet

[29/06, 10:52] Aakash: 'Application.OnTime Now + TimeValue("00:00:10"), "hello"

Thursday, June 23, 2022

Automatic script formula

Telegram automatic

var thesh = SpreadsheetApp.getActive().getSheetByName("Setup").getRange(26, 2, 6).getValues()

var token = thesh[1][0]

var fastSend = thesh[2][0]

var imprange = thesh[4][0]

var norepeat = thesh[5][0]

function onOpen() {

var ui = SpreadsheetApp.getUi();

ui.createMenu('Telegram')

.addItem('Send Now', 'telegram')

.addToUi();

}

function setTrigger(){

removeTrigger()

var time = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Setup").getRange("C15").getValue()

createTrigger(time)

}

function createTrigger(time) {

var ss = SpreadsheetApp.getActiveSpreadsheet();

ScriptApp.newTrigger('telegram')

.timeBased()

.everyDays(1)

.atHour(time)

.create();

}

function createTriggerOnChange() {

var ss = SpreadsheetApp.getActiveSpreadsheet();

ScriptApp.newTrigger('telegram')

.forSpreadsheet(SpreadsheetApp.getActive())

.onChange()

.create();

}

function removeTrigger() {

// Loop over all triggers.

var allTriggers = ScriptApp.getProjectTriggers();

for (var i = 0; i < allTriggers.length; i++) {

// If the current trigger is the correct one, delete it.

if (allTriggers[i].getUniqueId() == allTriggers[i].getUniqueId()) {

ScriptApp.deleteTrigger(allTriggers[i]);

break;

}

function telegramf() {

var throttle = 0

var nlen2 = 0

var ss = SpreadsheetApp.getActiveSpreadsheet()

var sheet = ss.getSheetByName("Data")

var lastRow = sheet.getLastRow() - 1

var date = new Date()

var data = sheet.getRange(2, 1, lastRow, 12).getValues()

var data1 = sheet.getRange(1, 1, 1, 12).getValues()

var end = data.length

if (fastSend === "Yes") {

var nlen2 = data.filter(function(value){return value[11]}).length

}

if (imprange === "Yes") {

var end = data.filter(function(value){return value[0]}).length

}

var messaget = ss.getSheetByName("Template").getRange("B1").getValue()

for (var i = nlen2; i < end; ++i){

if (throttle >= 8) {

Utilities.sleep(10000)

throttle = 0

} else {

throttle = throttle + 1

}

var message = messaget

var row = data[i];

var mobile = row[0].toString()

if (row[10] <= date){

for (var g = 1; g < 11; ++g){

var temp = row[g-1]

if (temp instanceof Date) {

temp = temp.toLocaleDateString("en-US")

}

var message = message.replace("$("+data1[0][g-1]+")",temp)

}

var existinStatus = data.filter(function(value){

if (value[11].toString() === message) {

return "yes"

}

})

var strictNoRepeat = existinStatus.length

if (norepeat === "Off") {

strictNoRepeat = 0

}

if (message != row[11] && strictNoRepeat === 0) {

if(sendMessage(mobile,message) === 1){

sheet.getRange(2 + i,12).setValue(message);

} else {

sheet.getRange(2 + i,12).setValue("Failed");

}

function sendMessage(chat_id, text) {

var data = {}

var allContacts = chat_id.split("&")

try {

for (var i = 0; i < allContacts.length; ++i){

var number = allContacts[i]

data = {

method: "post",

payload: {

method: "sendMessage",

chat_id: String(number),

text: text,

parse_mode: "HTML",

disable_web_page_preview: true

}

var sendNow = UrlFetchApp.fetch("https://api.telegram.org/bot" + token + "/", data);

var b = sendNow

}

return 1

} catch (e) {

return 2

}

function telegram() {

var lock = LockService.getScriptLock();

lock.waitLock(60000);

telegramf()

lock.releaseLock();

}

Thursday, February 24, 2022

Screen recording appp

https://apowersoft-screen-recorder.en.download.it/downloading