How do I create a pivot table based on data combine from multiple files based on the months?
For example in my folder I have files using dates.
I want to combine all this file from that month for example all files from January in one excel and produce a pivot table based on the combine data.
For the pivot part, I might use Macro to do it.
Thanks in advance