Search results

dear Seemanto, thank you very much for your assist, and i apologize for my late reply. regards, bigMe

hi friends, i need some help for my task. i have a dynamic data and what i want to do is copy and paste into new file for each rows that contains the same customer name and named the file with it and also sum the amount in column H. herewith i attach the source file and the result of new file...

dear Rahman, thank you very much for your help.... regards, bigMe

hello, i need help how to check each row to find duplicate, but it must identical from A to C, if one of the cells is different then it's not duplicate. after find the duplicate data, i need to copy all the non duplicate data to other sheet (sheet2) and clear all the duplicate data in sheet1...

thank you... and more thank you for you dear Yousuf.... :love: regards, bigMe

Private Sub TarikDataKoreksi() Dim lr, lrow, i As Long Application.ScreenUpdating = False Application.EnableEvents = False Application.Calculation = xlCalculationManual Sheet_Name = "Form Faktur" 'to select folder contains workbooks Set File_Dialog =...

Dear Yousuf, once again....... your code help me a lot, thank you very much......👍 best regards, bigMe

dear friends, i have a macro and it's work fine if i run it from the VBA windows, but when i assign to a button, nothing happen, can someone help me with this issue? for other macro work fine with the button. here is my macro : Sub doubelKoreksiFaktur() Dim lastRow As Long Dim x As Long Dim i...

good morning friends, i have a task to copy data from a list of file. i try some code but is not working :cry: what i try to do is open the file and copy using used range (but without the header) and paste it to sheet Monitoring then close the file and open next file in the list do the same...

dear Yousuf, I have try your code, and it's work very excellent..... 🤩 thank you for your help.... best regards, bigMe

dear friends, i have a workbook with 2 sheets. in sheet1 in column A contains values in sheet2 in column A contains values i want to delete every rows in sheet2 if the value not match with value in sheet1 thank you. regards, bigMe

Dear Arif, a big big thank you for your help....🤩 regards, bigMe

dear Arif, thank you for your kind help. I just wondering, if this code also run when i have new data and want to add into the last row of existing data? regards, bigMe

Halo friends, kindly help me, i have two table each in different workbooks, the data in table1 will be move to table2 as a master data, since the header not exactly in same sequence how to add data from table1 to table2 based on the header? and also continuously add new data form table1 to last...

dear Yousuf, thank you for your assist, but it seem this is not what i'm looking for.... since my email body not refer to any cells, it was a variable named ibody. i just want to turn/change the text in last row in my ibody into the example i've show above, thank you. regards, bigMe

dear friends, i have a variable ibody as my email body, and it's works fine, i just need to change a little bit part of the text, how to do that with VBA, thank you. note : focus on the text Runs by MACRO AUTOBOT + alpha symbol (font type britanic bold) regards, bigMe

thank you very much for the assist, it really helpful :love: best regards, bigMe

dear friends, please help me on this matter. i have 2 sheets, in sheet1 contain the Max value address and a number, in sheet2 a column contain several number and a column for result i need to do a VBA calculation in sheet2 to the MAX value so the result equal with value in sheet1 using copy...

Dear Assasins, thank you for your explanation and the problem already solved... :love: regards, bigMe

thank you very much for the explanation, now it's works... (y) need one more explanation, if the value changes not directly do in the cells, for example using goal seek why it don't work? is a modification needed in the code? best regards, bigMe