My apology for late response Mentors, im afraid but I dont have any back-up of it that is why, ^_^ thats all I have, anyways mentors thank you so much for the help, you were all the best have a great day everyone!!
Thank you for the info SirJB! but if we convert it into xlsm in that format the errors arises, anyways sir if there is no difference between xlsm and xlsb ill stick with xlsb same features but lighter size , thanks a lot Mentors. ^_^
here it is sir Hui, yet I dont have idea sir if there is something really are missing, but the last time I use it, it was perfectly fine, by the way Sir what's the difference between xlsb & xlsm, my apology Sir coz Im still a newbie I just rely on internet resources, Thanks a lot Sir, have a...
Hi Mentors hope someone could help fix my problem, I cant upload my file here coz it was 2.59 MB size and i dont have idea how it does, but when I converted it into xlsb file it was 492 kb only, and my maor problem is when it was in xlsm file i cant open it properly and pictures below keep on...
You got it Sir Vletm, but why does it took so long every time I put data in every cell it takes 3-4 seconds, and more than a minute on clicking the ENTER button? got any more tricks Sir? thanks a lot sir Many many thanks!! ^_^
As seen everytime i click enter the destination worksheet based on column C the worksheet also appears, what I need Sir is everytime i clik the enter button they remain hidden, here is their codes
Sub copyPasteData()
Dim strSourceSheet As String
Dim strDestinationSheet As String...
Hi Sir Belleke thanks your userform is great however Im still new in VBA thing I dont even know how to open the details distributed via userform, and the details I need to submit in different sheets was 18 cells in a row, in my template above everytime i click to copy paste button it did copy...
Hi Mentors! I hope someone could help I have created a template that could help me a lot in my work, but sadly I only have a very few knowledge in regards of VBA and all of those codes were just came from internet search, I need to paste the details in a identified sheets and I want them to...
Hi Good day! everyone MonioDee here from Philippines, Im an avid fan of excel VBA however there is no any short courses offer in my country regarding VBA, I have created some through copy paste via internet resources, I hope someday and someone could ever give a tutorial on how create or work...
OMG!!! hahaha i never imagine that Id been working with these for a days, that only has a simple solution just as simple as that, You made my day sir Bosco, Thanks a lot men have a greatest day!!! I owe you guys see you soon (^_-)
Thanks Rahul shewale, but what if the details or values from d1:k1 became rumble, that's why I need a strong formula that could gave me the values from c2:c9 once datas from a2:a1 & d1:k1 matches.
Guys what kind of formula should I used to identify the given amount once the given rows (name b2:b9) matches to the given columns (name d1:k1). sample I want to appear the amount of 10 to d2 when d1 matches to b2. guys please help me ive been working to this for many days already T_T