Example- col1 col2 col3
data1 data2 data3
data4 data5 data6
data7 data8 data9
Suppose data5 have value arquivo.
I have to extract whole row data which has value arquivo from excel and put in other excel
How to proceed? Can anyone please help.
|Fil1|informica|need to update value|
|Fil1|Avisa|need to update Pan valuw|
|Fil1|Successo|completed|
|Fil3|informica|need to update value|
|Fil3|Avisa|need to update Pan valuw|
|Fil3|Successo|completed|
Suppose if the last line of the column “File name” have value “Successo” then i want to extract all the 3 row of that file name.
eg- if Fil1 in the column “filesname” have value successo in its line then i have to write all the row of that Fil1 in excel sheet.
o/p
|files name|document|message|
|Fil1|informica|need to update value|
|Fil1|Avisa|need to update Pan valuw|
|Fil1|Successo|completed|
@Srini84
my query heere is that if last line of Fil1 contain Successo in column(document) then i have to extract all the row which has Fil1in column(files name)
But it worked for only 1 file but i have multiple files in input excel sheet which i have to filter in other sheet.
How to do that can u please explain?