filter and append strings from multiple sheet to one
Hi all
i have a lot of excel sheets. In every excel sheets there are a certain number of rows which start with the same title, then there are a blank rows and a list of rows that i d like to extract and append in one single file.
Ill make an example
this is the template for every file (i have a folder with 300 more or less). I d like to extrapolate and concatenate for every file the part underlined in black. It is possible that in the first section there are a lot fo rows, so it s not the same “structure” in every file but the number of rows in every section change… i concatenated whit a excel reader but even if a row filtering the name of the section i dunno how to take the part under the “title” of the last section
thanks for all
byezz