Hi mynda Thanks for reply I have attached the sample file for your kind perusal. Rgds thulasi
Hi Anders Thanks for reply. I got it solved. In the month text in getpivotdata, I inserted "&cellreference&" and go it solved. Thank...
Thanks for reply. I understand and will attach a sample workbook for better clarifying.
Yes, understood. Thanks.
Thank you Catalin. The scroll down of data irks. The ctrl+arrow not working in query editor. Have to use page down. Is there any shortcut keys to ...
Hi Phil Thanks for reply. I have monthly trial balances from 4 divisions of a company. I created query for each trial balance which added upto ...
Thanks. Let me try.
Hi Catalin Bombea I have uploaded file for your reference.
Hi Catalin Bombea Thanks. I will attach the file for more clarification of my query. Thanks a lot.
Hi Catalin Bombea Thanks for your reply and suggestion. But I am sorry to say that I am unable to follow it. Sales, Direct exp, fixed exp are r...
