Keep last 2 rows of each worksheet from multiple files after filtering empty rows

[wbstadeli]

Hi!

When using the new query>from file > from folder > "select folder" >edit, this loads all the files from that folder into the editor. What do i need to do to load all the data from a sheet called "Work Order" remove all empty rows in column 5, and the keep only the last 2 rows of data from EACH sheet, not only last 2 rows of from all the data in the editor (which contains multiple sheets pulled from all the files in the folder). Thanks for any help with this!

 

[VBA Geek]

You are going to need to share your source file, otherwise its impossible for anyone to help with this

 

[nikio8]

it is a bit confusing, here are some ideas you can use:

the last step. open one sheet, new column - index. filter descending. keep rows - top two rows

save it as function.
pass the rest of the sheets in.

when you expand the data keep the column with sheet names.
filter by "work order"
expand data
click column 5 - reduce rows - remove errors OR unfilter null