using libreoffice and collating data from multiple sheets. using INDEX and MATCH formulas if you need an alternative to vlookup. And using SUMIFS to sum values that are within a date range.
useful links
Listing all tabs
https://ask.libreoffice.org/t/is-ther...
Sum between dates
https://ask.libreoffice.org/t/solved-...
Return value left of lookup
http://www.excel-university.com/how-t...
thankyou for watchig
0:00 Introduction
2:08 using Navigator menu
4:08 INDEX and MATCH formulas
12:28 SUMIFS formula
15:59 thankyou for watching