Search results

hello, i wonder, is there any way to compare text between 2 cells by ignoring upper/lower case, punctuation, not in the same order, min. 2 words same is okay. regards, bigMe

thank you and more thank you...... :love: :love: :love: regards, bigMe

Dear Seemanto, kindly help me with your code above, which part do i have to modified if i want to copy every sheets that contains data from every single files that already opened and joint all that sheets into 1 workbook (in this case need to add a new workbook), really appreciate your help...

dear Seemanto, huge thank you for youe help, i just need to confirm about this...., in the declaration it said "Dim subsub_folder As Object" but the syntax said "For Each sub_SubFolder In sub_folder.Subfolders". is it just a typo or not, thank you. best regards, bigMe

hi everybody, i need help and let me explain the situation : 1. i have a folder ABC (example) 2. in this folder ABC contain sub folders (Folder A, Folder B, Folder C) 3. in each sub folder contain more sub folder (Folder A contain folder A1, A2 etc) 4. in each sub sub folder contain files...

wow...amazing.... thank you very much, what you share beyond my expectation (y) (y) (y) (y) (y) (y) best regards, bigMe

Dear Lutfor, thank you very much for your help...., can i ask for little more favor ? :giggle: if i change the source become 2 column and only show into list box the complete one only, which part of the code needs modification? thank you. regards, bigMe

dear friends, kindly help me how to show data in range of column into listbox but only cells with value, thank you. regards, bigMe

dear Seemanto, a huge thank you for your assist, the is problem solved, i learn a lot from your explanation, thank you once again. i hope i can learn more from you in the future. best regards, bigMe

Dear Seemanto, thank you for your enlightenment, i try this new code but i get error every time i try to update the same ID (please see my attachment), but in the sample you gave there is no error, it works fine, it's driving me crazy to find the problem, please kindly help me, thank you...

dear Seemanto, i have a little problem regarding to the array Code: ufArr = Array(ufNm, ufAdrs, ufCt, ufID) The values of the variables ufNm, ufAdrs, ufCt, and ufID are stored in the array ufArr in the given order. since the sample i given was column A,B,C,D what if i insert new column that...

wow...... thank you very much..... :love: :love: :love: thank you for your kindness for helping me.... best regards, bigMe

Hi, Yousuf, thank you for the explanation, but can we do it using VBA instead doing it manually one by one? thank you. regards, bigMe

thank you and thank you..... your explanation is very clear and easy to follow, thank you. regards, bigMe

Dear Yousuf, very big thank you for your help, according to your explanation, the data should be transform into table format, this makes a new case... how do i change each data into tables? since in the sheets there are several data (in this sample the data become 6 tables) please help me with...

dear Seemanto, a huge thank you for your help, if you please, can you explain the steps of the existing code? so I can understand more. thank you. regards, bigMe

good day friends, i have a task and i have no idea how to solve it. task : Note : column D (ID No.) as the key first entry data will be store in 2nd rows below headers and it will reserve 12 rows down, so when i entry new data it will check the ID No. if it is match data copied to the next...

dear friends, i have a sheets (name : source) that fill with several small table, kindly help me how to copy each table to other sheets (name : template) and print it, and clear the table before next table copied to template, till the last table, thank you for your help. regards, bigMe

thank you very much for your help brother..... 🤩 best regards, bigMe

dear friend, i want to use spin button to show month and year in a cell, how to do that? please kindly assist, thank you. regards, bigMe