Find in column and Copy it's row code for Google s
Closed
Hello,
I have created code in MS Excel for finding particular text in column and after finding text the entire row should be copy and add in next sheet after the Last entry but this code is not working for Google sheets.
can you please help me to create same code for Google sheets thanks in advance
I have created code in MS Excel for finding particular text in column and after finding text the entire row should be copy and add in next sheet after the Last entry but this code is not working for Google sheets.
can you please help me to create same code for Google sheets thanks in advance
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
- Code 257 google tv - Guide
- Cs 1.6 code - 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