Search results

  1. B

    [Solved] need correction to my code

    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")...
  2. B

    [Solved] How to send email for each customer in pivot table

    thank you very much... it's works....:D
  3. B

    [Solved] How to send email for each customer in pivot table

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

    [Solved] How to send email for each customer in pivot table

    wow...... amazing.... i will try your solutions... thank you very much Mr. Saquib regards, bigMe
  5. B

    [Solved] How to send email for each customer in pivot table

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

    [Solved] how to hide rows and the total summary also change

    Dear Mr. Yousuf, thank you very much your code is very useful. regards, bigMe
  7. B

    [Solved] how to hide rows and the total summary also change

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

    [Solved] how to hide rows and the total summary also change

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

    [Solved] error invalid qualifier

    dear Ms/Mrs. Shamimarita, thank you. regards, bigMe
  10. B

    [Solved] error invalid qualifier

    once again, you solved my problem, thank you very much. regards, bigMe
  11. B

    [Solved] error invalid qualifier

    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") = _...
  12. B

    [Solved] Add data to last empty column

    Dear Mr. Mashhura, Thank you for your help, i've tried and it's work fine as i expected. Your code will save me a lot of time. Best Regard, BigME
  13. B

    [Solved] Add data to last empty column

    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 :

Online statistics

Members online
0
Guests online
13
Total visitors
13

Forum statistics

Threads
303
Messages
1,331
Members
550
Latest member
JasonRip
Top