Related:
- Find in column and Copy it's row code for Google s
- Google meet download for pc - Download - Video calls
- Battery reset code - Guide
- Samsung volume increase code - Guide
- Usa country code for whatsapp - Guide
- How to get whatsapp verification code online - Guide
2 responses
Yes , but being a mech engg i dont have knowedge of it and struglrd a lot , thats why i did this post
Thanks master for your reply, I do not have any company, this code just for personal level.
Inspired by you , somehow i have done this code
function given() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var s = ss.getSheetByName('Sheet1');
var r = s.getDataRange();
var v = r.getValues();
var arr = new Array();
for(var i=0;i<v.length;i++) {
if(v[i][0]==='Table') {
arr.push(v[i]);
}
}
var t = ss.getSheetByName('Tabledata');
t.clearContents();
t.getRange(1,1,arr.length,arr[0].length).setValues(arr);
};
This is finding "Table" text in column A and copying respective row , after this step it's going to sheet name "Tabledata" and clean it and pasting .
I have played a lot of code and searched a lot on net but really not getting any solution, hence I am asking help of masters as like you .
I want to do is.
1) It should find Table name in column D instead of column A
2) after copy it should paste in next empty row
Thanks & regards
Inspired by you , somehow i have done this code
function given() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var s = ss.getSheetByName('Sheet1');
var r = s.getDataRange();
var v = r.getValues();
var arr = new Array();
for(var i=0;i<v.length;i++) {
if(v[i][0]==='Table') {
arr.push(v[i]);
}
}
var t = ss.getSheetByName('Tabledata');
t.clearContents();
t.getRange(1,1,arr.length,arr[0].length).setValues(arr);
};
This is finding "Table" text in column A and copying respective row , after this step it's going to sheet name "Tabledata" and clean it and pasting .
I have played a lot of code and searched a lot on net but really not getting any solution, hence I am asking help of masters as like you .
I want to do is.
1) It should find Table name in column D instead of column A
2) after copy it should paste in next empty row
Thanks & regards