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 Mr. Saquib,
after i try and run your code, its not exactly what i'm looking for...
i'm convert my excel and still confuse how to send each current region (yellow highlight) as a email body and send it with list of email address in other sheets so it will create multiple email, could you...
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 Ms/Mrs Shami
thank you for your explanation, could you kindly help me for the vba code to hide rows based on condition and do the aggregate, 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 :