I’m stuck in my project and i can’t find a solution.
I explain myself, I try to read an excel file and a spreadsheet and when there is a match (the text of the both column of the excel and the spreadsheet are the same) to write the content (of the row +1 on the right of the Excel match) in the correspondig row(+1 in the right) of the match in the google spreadsheet. And that for each match between the excel and the google spreadsheet.
Thanks in advance for your help, you will save my life guys.
Hi @arivu96 …I have 2 excel and they both have date column in them…if the date matches then i need to write the rows from first sheet to the second…Currently I have first sheet as data row as i had to filter…I am reading range from Second sheet and storing as datatable…Can you please help?