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

    Disable right click for copy cut paste only

    this enable the keys Sub Enable_Keys() Dim StartKeyCombination As Variant Dim KeysArray As Variant Dim Key As Variant Dim I As Long On Error Resume Next For Each StartKeyCombination In Array("+", "^", "%", "+^", "+%", "^%", "+^%") KeysArray = Array("{BS}", "{BREAK}"...
  2. V

    Disable right click for copy cut paste only

    Hi, See if it is help for you. ThisWorkbook: Option Explicit Private Sub Workbook_Activate() Call ToggleCutCopyAndPaste(False) End Sub Private Sub Workbook_BeforeClose(Cancel As Boolean) Call ToggleCutCopyAndPaste(True) End Sub Private Sub Workbook_Deactivate() Call...
  3. V

    Sumif formula on the month basis

    maybe =SUMIF(A3:A14,"<="&(EOMONTH(TODAY(),-1)),B3:B14)
  4. V

    Lookup with Multiple Criteria (date and amount)

    Hi, Is this what you are looking for?
  5. V

    Employee Retention Formula

    Hi, The chart was written by mistake but here you can find a solution.
  6. V

    Vlookup function over multiple worksheets

    Another approach... but this is array formula: =VLOOKUP(A1,INDIRECT("'"&INDEX(ListOfWorksheets,MATCH(1,--(COUNTIF(INDIRECT("'"&ListOfWorksheets&"'!$A:$B"),A1)>0),0))&"'!$A:$B"),2,0) and press CSE Note: define the name of worksheets in ListOfWorksheets by Name Manager.
  7. V

    Find value based on criteria and partial text

    Hi, Great, thank you!
  8. V

    Find value based on criteria and partial text

    Hi, I have tested but the formula doesn't working for me.
  9. V

    How to insert 2 colors in a single cell.

    Hi, Something like this? Sub Test() With Selection.Interior .Pattern = xlPatternLinearGradient .Gradient.Degree = 90 .Gradient.ColorStops.Clear End With With Selection.Interior.Gradient.ColorStops.Add(0) .Color = 255 .TintAndShade = 0 End With With...
  10. V

    Find value based on criteria and partial text

    Hello, I would like to ask some help regarding that how to find a value based on criteria and partial text. There is one condition: the different partial texts should be managed inside the formula (not store in range). I have atteched a sample file with the desired results. Thank you in...
  11. V

    Remove letters from range

    Thank you Guys!
  12. V

    Remove letters from range

    Hello, I would like to ask that what is the fastest way to remove all letters from a range in one shot? In range G9:G the numbers ended with base units, like PC, KG or L and etc. Could you help me to figure out a code which can remove all letters (English Alphabet) from this range? This is the...
  13. V

    Date format problem

    Hi vletm, Debaser, Wow... thank you!
  14. V

    Date format problem

    Hello, I would need your help to solve a date format problem. I use the below mentioned code but doesn't work well. Option Explicit Sub Test() Dim OutputSheet1 As Worksheet Dim OutputLastRow1 As Long Set OutputSheet1 = Worksheets("Calculation") With OutputSheet1 OutputLastRow1 =...
  15. V

    Find the 2nd value based on more criteria

    Thank you very much!
  16. V

    Find the 2nd value based on more criteria

    Hello, I would need your help to find the 2nd value based on two criterias (Storage and Order number). Please, find attached my sample file with the desired result (cell M9). Thank you in advance the help!
  17. V

    Radial bar chart

    Wow... this is brilliant Hui! Thank you the help and that you shared your awesome knowledge!
  18. V

    Radial bar chart

    Thank you Hui the help. Could you give me one more advice... how to add the "black bar" to the chart with "start and end line" and major tick marks (cross)? Is it possible?
  19. V

    Radial bar chart

    Hello, I would like to reproduce a radial bar chart but i can not figure out, could you please help me to do this?
  20. V

    Making a macro

    Hi sayedsiddiq, Is this proposal help you? Just press the command button.
  21. V

    Return blank cell if result is 0

    Thank you Debaser!
  22. V

    Return blank cell if result is 0

    Somebody has other idea?
  23. V

    External table is not in the expected format

    Hi, Thank you the tip, I check it tomorrow.
  24. V

    External table is not in the expected format

    Hi, I would like to ask your help regarding data transfer from closed workbook. After many attempts I feel that I am completly lost. The attached Components.xls file generated by SAP and when I want to transfer the data I receive "External table is not in the expected format" error message. By...
  25. V

    Return blank cell if result is 0

    Hi Narayan, I tested the above mentioned code but doesn't work for me as I expected. Could you please see the attached file?
Back
Top