My work has kept me both busy and moving for the last 6-8 weeks now. As part of that I had to travel again HK for another brief visit. I have come here yesterday and will be here till the end of this week. Hopefully I can get back to my normal life and blogging after this.
Recently I had to create a Pivot report from monthly data. But there is a twist. The data is spread across multiple sheets, one for each month. Let me explain how I built the pivot for that scenario.