Search results

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 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

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 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

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...

Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Target, Range("C11")) Is Nothing Then Range("C15") = Range("C11") * Range("D15") Range("C19") = Range("C11") * Range("D19") Range("C20") = Range("C11") * Range("D20")...

dear Friends, i have a pivot table, and have no clue how to send the data for each customer by email, hope someone can help me, thank you. regards, bigMe

Dear friends, kindly help me, i have a table with some number in it and i sum for total. problem came up when i hide a few rows but the total doesn't change according to the showing number. is there any code to solve my problem? thank you. regards, bigMe

dear friend, kindly help me, which part of this code is wrong? thankyou, BigMe Sub hitung() If Worksheets("Quotation").Cells("C2") = "TH-K45R" And Worksheets("Quotation").Cells("C3") = "REGULER" Then Worksheets("Quotation").Range("C12") = _...

Good Morning, i have a table and every day i do manual vlookup every time there is a new data, please help me to create a macro so when new data arrive, i just run the macro. thank you for the help. example data :