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

    Run time Error 91 - Code Error

    Hi Friends, Need your help in highlighting my error for the below code. 'Define the variables in the sheet of the macros Workbooks(wbmacro).Activate Sheets(Acc).Visible = True Sheets(Acc).Select ''Look in what row are the titles Dim MRow As Integer: MRow = Cells.Find("MMS ID").Row...
  2. D

    count no of occurrences from a time interval

    thanks Vltem..but I guess I was not able to convey the right message to you. let me try again : I have dates with dates having time intervals in column A , and planned dates in column G. lets say when between 12/30/2018 the planned dates has only 11/12/2018 hence we will count it as 1 again...
  3. D

    count no of occurrences from a time interval

    Hello Friends, I need your help in getting the no of occurrences for a time interval from a range of dates. for example in column A we have time intervals for 15 days between the dates and from column G we have planned dates , now in column B we need to count the number of occurrences that...
  4. D

    Find a letter "O" and convert the number in Negative in another Range

    Hello Friends, Need your help here ..I need to find a letter "O" from the range column T and convert the existing number in column L to negative. For Example: Row no 10 having 71.58 should be changed to -71.58 similarly Row no 26 should be also changed to -71.58. Appreciate your help on the...
  5. D

    Vlookup and Is number Formula using Vba code

    Thanks Vletm..for highlighting the error. I could manage to crack the requirement for most of the scenarios but could not able to get the formula ....=IF(ISNUMBER(FIND("I",T2)),"Internal","External") in colunm CG. The reason for the getting it to run through vba is one of the requirement where...
  6. D

    Vlookup and Is number Formula using Vba code

    HI All, I am getting the following error while trying to enter a formula using vba. Appreciate your help
  7. D

    Vlookup and Is number Formula using Vba code

    Hello Friends, Need help on running the below formula on columns CE and CF and CG using Vba. The range is dynamic in nature and not constrained to constant. Appreciate your help on the same. CE =VLOOKUP(AK2,'Country – Service HUB'!A:C,3,0) CF =VLOOKUP(AK2,'Country – Service HUB'!A:B,2,0) CG...
  8. D

    Updating output with first letter as "I"

    thank you all its working ..Appreciate your help
  9. D

    Highlight Duplicate Records using Vba

    thanks Vletm
  10. D

    Updating output with first letter as "I"

    Hello Friends, I need help in getting an output in location column as "Internal" if column A starts with letter "I" any other text or number should be " External" Appreciate your help here.
  11. D

    Highlight Duplicate Records using Vba

    Hi Vltem, A small change , I wanted to run this on the sheet name called "KPI". so can we change the With ActiveSheet to With Sheets("KPI").Select ---------------------------------------------------------------------------- Sub Do_It() Application.ScreenUpdating = False With...
  12. D

    Highlight Duplicate Records using Vba

    Thanks Vletm ...perfect as always Appreciate your help:)
  13. D

    Highlight Duplicate Records using Vba

    Hello Friends, I need some help regarding find duplicates from column F and rename column CF as "Yes" and "No" if there are any duplicate records in F. Appreciate your help here. Attached sheet for your reference.
  14. D

    Vlookup on the last columns for a range

    Thanks Vletm...one minor change .The below columns headers will be not be existing in base sheet while copying the extract from other file. can we insert a header as " country" and "region" along with while running the code. Thank you.
  15. D

    Vlookup on the last columns for a range

    Thanks AlanSidman, Need your help in v lookup for the last two columns of the data using vba . The last two new columns should be name as country and region.
  16. D

    Dynamic Pivot pie Charting

    Thanks Vletm ...this is more presentable...thank you very much. I really appreciate your help here
  17. D

    Vlookup on the last columns for a range

    Hi Team, I have a data where in the range differs from one period to another. Need your help in vlookup for the last two columns of the data using vba . The last two new columns should be name as country and region. Appreciate your help here
  18. D

    Dynamic Pivot pie Charting

    Thanks Vletm for the support. the ask for me was to create only the "Total Value of Average of C Value and count of Ckey " in the pie. But the challenge here is everytime a new KPI is added , we have to change range the new KPI accordingly. I have added KPI K in the base and while refreshing...
  19. D

    Dynamic Pivot pie Charting

    Hello All, I have few data points where in I need to insert a separate column for average of two variables.The average column is manually inserted. I have a challenge in pie chart where in I have to show: Each KPI Week wise Average ( Depends upon on number of KPI's in Header) All KPI together...
  20. D

    Help ..Background color to Header

    thanks Hui...much appreciated .
  21. D

    Help ..Background color to Header

    Hello Friends, I need you assistance here , I have to fill in the header of each of the worksheets for the below code with Amber . This code is for copying data from one folder(containing multiple workbooks) to a single work book in to different worksheets . Now when the data is copied and...
  22. D

    Help ..Code for copy data in to master workbook in different worksheets

    Hi Vletm 1) Is this 'once-in-the-lifetime' or daily action? Daily action 2) Is range always same with each file? no, the range is not constant across all workbooks 3) Have You tested to do that copy manually? ... about ~five steps, if five files -->>> Maximum the files can be 7 and...
  23. D

    Help ..Code for copy data in to master workbook in different worksheets

    Hi Vletm, Thanks for your reply, 1.this is a lifetime activity which is my bread and butter. 2.yes there is always a single worksheet in all 5 workbooks but the range is different. 3.this data is picked up by the client from the C:\temp where we run a dashboard on it by running some formulas...
  24. D

    Help ..Code for copy data in to master workbook in different worksheets

    Hello All, I have to copy data from 6+ workbooks and paste it into a master workbook in different worksheets . All the workbooks are located in a folder on my desktop: C:\Users\xbv\Desktop\TestFolder Request your help here please. output :
  25. D

    Need help using formula to get output

    Thank you Vletm and AliGw.....appreciate your help .
Back
Top