Hi Catalin, I've removed On Error Resume Next, but still the error pop out. All the password is same still 1234, as i tried to run the unprotec...
Hi Catalin, Good day to you. Several years I am back again for the same vba project, related issue but having error as attached. I've been usin...
Hi Phil, I think i will continue with VBA and put up with it. I need to use MySQL as all of my application are hosted there. Our server is on vi...
Hi Philip, I did't try to upload workbook with SQL but pasted macro with SQL coding at here having the error. Yes you are right, I am doing the ...
Hi Philip, The reason i can't add the SQL here is because I get access denied - Sucuri Website Firewall (Block reason: SQL injection was detected a...
I cannot attached the sql coding here so i attached in picture for my macro coding.
Hi Sunny/Catalin, Thanks for both help. I am sorry that i should attached the desire sample result for clearer concept. Please refer to sheet 2....
Hi Sunny, Can you help me for another issue related to the helper column that you teached me last time. I wanted to sort the top 5 values based ...
Hi Sunny, Quite a good idea also, Thank you very much! I am working with it now. 🙂 Best Regards, Hooi Thin
Hi Sunny, Thanks for your solution, it works. 🙂 But what i want to display out on my project is stay back the same SR Account Name at first col...
Hi Catalin, I didn't know can manually protect directly at that worksheet. 😀 Sorry for any inconvenience caused and really tons of thanks to yo...
Hi Catalin, I think i just put the two tables below the percentage table by leaving more spaces between them.I think it shouldn't be overlap the pi...