Hello ppl,
Need help about excel possibility in general. I have excel report generated by Odoo ERP and I want to make PIVOT analisys on it, but it is not formated well. It's a large scale document with all possible data and every month gets bigger.
Is it possible to make a excel template file that can make quick large scale formatting every time I make new export.
There are two kind of formatting:
- one is just cell type formatting and text to columns thing
- other would be adding sheets with lists that will be used for VLOOKUP and adding new categories to original sheet.
Can it be done by templating or is it maybe easier to make complete new table that will cross-link every data from that ERP exported file ??
Thank you!
BR,
Davor
Bookmarks