• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. J

    Help in time Calculate Slab

    Hi, Thanks V Much for your time.
  2. J

    Help in time Calculate Slab

    hi friends, I have one doubt in time calculated formula. I enclosed the sample file for your reference, I have given the slab and time please help on same. Regards Jawahar P
  3. J

    Help in if condition Formula

    Hi Team, we have date with Time in A & B Coloums result in C Coloum A-B in C if Day <=24 should updated "Y" or "N" enclosed sample data for reference Please help on same Thanks Jawahar Prem
  4. J

    IF Formula Error

    Hi Bosco, Thanks its working...
  5. J

    IF Formula Error

    Hi Team, Conduction if camp P2P and days <=90" should updated as "A" if camp MNPand days <=120" should updated as "A" I tried in OR,AND,XOR please I not getting proper output please help on same. sample data enclosed for reference. Thanks Jawahar
  6. J

    Help in VBA Copy, Paste and vlookup

    Hi, Please help me this macro 1. in master base Q column need to take only <> null and paste in "calling sheet", "B column" (need to take only Q column not overall data) 2. in "calling sheet" need to map the cust_name1 & cust_name2 from "mapping sheet" using "G Coloum" 3. in "calling sheet"...
  7. J

    help on sumifs formula

    Hi,. S, thanks for your time.
  8. J

    help on sumifs formula

    Hi All, need a sumifs formula agints marks and name output required pass or fail. sample file enclosed for reference. thanks jawahar
  9. J

    Copy, Paste, Vlookup Macro code Needed..

    Hi Nebu & Jaya, Thanks for your time working fine...
  10. J

    Copy, Paste, Vlookup Macro code Needed..

    Hi, thanks for your time, i have tried this macro by getting some error can u please help on same file enclosed for reference. Option Explicit Sub copyrows() Dim lRow As Long Dim lCol As Integer Application.ScreenUpdating = False Sheets("Master Base").Select lRow = Cells.Find("*"...
  11. J

    Copy, Paste, Vlookup Macro code Needed..

    Hi, i need a vba code for mentioned critra. 1. in master base @ coloum C only "AA" & "AAA" should move sheet named C 2. in master base @ coloum D only "AA" & "AAA" should move sheet named D After moving i need a vlookup with C & D sheet againts "ALLOC" sheets ref the the coloum names...
  12. J

    Hello .. Introduce yourself

    Hi All, Iam Jawahar Prem from India, Tamil Nadu. i really like this site it helps me a lot in work
  13. J

    Help on Login time calculation

    Hi All, Please help on this query, i need to know which employess are comming late from their loging time, if the emp login time is 9.30 while he reaches by 9.40 in rem coloum a text should to display as Late commer or on time. i enclosed sample file for your reference. Thanks Jawahar Prem
  14. J

    Help Req on - Date Calculation

    Hi Asheesh, Thanks for your time, i have worked on this but i not getting the proper output, i enclosed the file and updated the remarks to understand, Please help on this. thanks jawahar prem
  15. J

    Calculation for days

    Hi, Thanks its working fine...
  16. J

    Help Req on - Date Calculation

    Hi All, please help in date calculation formula details given and file enclosed for reference. 1. i have offer Validaity month in B Coloum, offer act date F Coloum and BC Date in D coloum Now what i nedd to find out the offer closing date Ex - 1st Case - offer month 4, Offer act date is on...
  17. J

    Calculation for days

    Hi, i need help on this. REQ - need to find the days between previous call and present call, i have enclosed number and date, if number are same need to calculate previous date and last data to find days between. enclosed file for reference. Thanks Jawahar Prem
  18. J

    Chart has to change while dashboard changes

    Hi, Thanks but its not possible in macro, if its please help on same..
  19. J

    Chart has to change while dashboard changes

    Hi, in my file while iam change the dashboard, chart should change as data Ex if i select apr month data change should take april data, if may it should take may's. i enclosed my excel file format for reference. Thanks Jawahar Prem
  20. J

    Pastespecial VBA code error

    Hi, Thanks, but the same code works if the dasboard in sheet3 insteed of sheet2 iam getting error only in sheet2. Jawahar Prem
  21. J

    Pastespecial VBA code error

    Hi, Thanks for your time i copied your code and pasted but the same error, data has pasted in coloum in "B6" only blank..
  22. J

    Pastespecial VBA code error

    Hi All, in my sheet2 range(P6:Z23) dashboard, when i select april radio button the dashboard should paste in same fomate in ("b6) iam not getting proper output while iam running this code please help on same. excel file enclosed for reference.. Sub OptionButton1_Click() Rows("6:23").Select...
  23. J

    Help in VBA Code how to calculate coloums by month

    Hi, thanks for your timeits working.
  24. J

    Help in VBA Code how to calculate coloums by month

    Hi All, Please help on this code. i have a date in "J coloum" if Previous Month Ex "dec" data should be calculate from "C to I", and updated in k coloum. if current Month Ex "jan" data should be calculate from "D to I", and updated in k coloum. i enclosed sample file for your reference...
  25. J

    Help need for Slab against Time

    Hi Sir, Thanks for your time.
Back
Top