How's this? Items are now listed below each other. First column shows which sheet they came from. Having the branch as a tag doesn't really help too much, as data is still spread across sheets.Ciao Luke that was great!
Can I ask you some more help? Drink is paid if you solve this.
In attachment there's a spreadsheet based upon yours (I tried to minimize your tasks…), for the final adjustment I need the list of relevant document to be shown below each branch (sheet1 in red), thus inserting or deleting rows as needed. Is it possible?
One more thing, what if we consider also the branch as a tag? would the macro be slimmer? In case the column intersted is column T.
The very very last thing: actually I need only column E (title) and R (url) to be copied in sheet1, can you?
How's this? Items are now listed below each other. First column shows which sheet they came from. Having the branch as a tag doesn't really help too much, as data is still spread across sheets.
You sure? That would make them behave in an AND type condition. I was initially assuming you wanted an OR type condition.
Anyway, to do what you ask, need to make the criteria be in same row, which isn't too hard. Check out Formulas sheet for changes.