Hi Riny, Please see the attahced update file.
Thank you Riny. Please see the attached sample file. The first tab is the actual data file, which I will be receiving on a monthly basis. The secon...
Hi Riny, Previously I manually added a row with these headings (M1A, M2A...so on) A2:L2. Via PQ I was loading the table under these headings in A3:...
Hi Riny, Thank you very much for providing the solution. It is working for me. Now related to this I need one more favour. Basically, I want to ...
Hi Catalin, Thank you for your reply. I have thought of another way of doing it and that is working. I really appreciate your response on thi...
I am happy as long as the query is working and the desired outcome is achieved. I cannot see any attached file. Is there any? If you could attach i...
Thank you for your reply and my apology for the late response. I have now understood the file is working correctly as per my need, but there is one...
The problem is the Lookup table values can belong to any of the FY, e.g: 20-21, 21-22, 22-23. So we cannot allocate FY to it by creating a new column ...
Thank you Riny. Please see the attached file with the expected results.
I have another query related to the same file, but I have added two more columns this time. Column A is for the FY and column E is for lookup value. T...
Thank you for your explanation and for providing the solution. It is working exactly the way I wanted. Sorry I cross-posted this question at chando...
Hi Riny, Many Thanks for your reply and for coming up with the solution. Yes, this is exactly what I want, but on my file, it's not working. I m...