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

    Identify Top 2 and Lowest 2 Value and include in Comment.

    Hi Team, I am looking for some ideas/dynamic formula, to make my comments dynamic based on the sales results from each region. attached is an example.
  2. R

    Mail Merge Replace text

    Hi Team below is the code i have in an excel template to replace text on body of the mail with some values. However while i run code only two texts are getting replaced can you please help. >>> use code - tags <<< Sub DistributeReports() If MsgBox("Please confirm if the default signature for...
  3. R

    Calculate cost per day basis category

    Hi Team, I am looking for formula to calculate the cost that should charged for holding the package. Below is the example . for 0-5days no charge $0 charge from 6thday to till 10th day it will $2 per day , so if its 7 days it would be 2days * $2 = $4 and for 10 days it would be $10 the catch...
  4. R

    Identify Offset Line

    Hi there, I am looking for a formula or a vba code that code identify the offset line in a huge data set. Below is a sample. Thank you .
  5. R

    Dynamic Index

    Hi Team, I am looking for a way were we can make the Index dynamic , i mean based on the date in the attached file in the Sheet1 on Cell C5 the Index should change to respective column in Sheet2 . For Example if date in Sheet1 Cell C5 is 3/13/2020 then the Index formula should be changed to...
  6. R

    Marking Status with criteria

    Hi Team, I have the 6 products listed and their status in next column , what i looking for is that if the product X status is found as 1 then i need the result to marking as 1 against all the rows where X is listed even though the status of the same against that specific row is not equal to...
  7. R

    Macro to lock cells with column criteria

    Hi Team, Need help with a macro to lock cells based on the criteria of column header, for example in the attached file , i need all cells locked with column header "Texas" i.e, from column D,H,L,P,T,X from Row 7 to 32. Thanks for your help.
  8. R

    VBA to create Multiple Pivots in different sheet based on one source

    Hi Team , I am looking for help , in creating a code which will need to create the Pivots in different tabs from the Given data in Sheet1 based on the Month. Appreciate you help in this regard. Raghava.
  9. R

    VBA to Get the IST time to excel from interent

    Hi Team, I need a vba code that will fetch the time from internet and save in excel file . i need this to compare the system time with the time from internet. I am looking IST time Regards Raghava.
  10. R

    Get the Value from a close file and file is in network drive

    Hi Team I need vba code that will have to fetch the value from a closed workbook which is saved in the network drive. The problem i am facing the that the network was mapped to letter "X", but the same is mapped to different letter. my network path is \\USXXXNN07\US-PATH while using...
  11. R

    VBA to Find the value in the next column of the cell having the required string in the array

    Hi Team, I am looking for sample vba code which will provide me the value of Column B, while the text in column A matches with specific text which searching through ARRAY. Currently below is the code i am using , if the edit can be made to the same that would great. once the Find text is...
  12. R

    VBA code to auto run on every Excel workbook at open event.

    Hi there, What is the best way to trigger a excel macro which will have to run when any excel workbook is open ,even when already an excel workbook is open on the window.
  13. R

    Highlight specific text in Userform Text box in Bold

    Hi Team, Please let me know how can we highlight the specific text only in User form Text box Text in Bold. Ex Text in Text box is " you ticket number is "123456", for further assistance contact Admin with Ticket Number". I need only the text in bold. 123456 and Contact admin with ticket...
  14. R

    Excel-Addin

    Hi Team, I need to create an add-in in Excel which will have to check every excel workbook that is open & active to see it has Sheets with specific name like ex "Source-101" & "Reporting-1001" and the if it find them in the work book then proceed to check if the Cell "N93" have the text "...
  15. R

    Sum (Sumif in VBA

    Hi , i receiving an error 1004 while trying to execute the below code . Sheets("result").Range("AC10").Formula = "=SUM(SUMIF(Data!A16:A" & DATAlROW & " ,{" Awards & Incentives","Rebate & Givebacks","Unbilled Adjustments","Fixed Fee Billing"}"", Data!G16:G" & DATAlROW & ")" Appreciate your...
  16. R

    Copy the data from Multiple sheets

    Hi Team, I need VBA code for Copying the Column A data from multiple sheets which defined in ARRAY and pastet them in the Same work Sheet1 Column A row 3. Problem i am facing is the lastrow of each sheet is different. Ho do I Loop the For Each Sheet code to get the data copied from the...
  17. R

    Sumifs with Color and statement as criteria

    Hi Team, I am recahing out to you to see if there is availability to do sum based on Color and annormal criteria . attached is the example for your reference. Thanks in advance for you help. Raghava
  18. R

    Actual Last row needed

    Hi , I have Xlsb file where by mistake i have updated formula in a column to last row ( 1048576) and saved it . Now i am trying to reset to actual end last row 1456 . While i am deleting row , excel gives me error saying that "Excel cannot complete the task with available resources. Choose...
  19. R

    Actual Last row needed

    Hi , I have Xlsb file where by mistake i have updated formula in a column to last row ( 1048576) and saved it . Now i am trying to reset to actual end last row 1456 . While i am deleting row , excel gives me error saying that "Excel cannot complete the task with available resources. Choose...
  20. R

    VBA code to reset the last used Row

    Hi , I have Xlsb file where by mistake i have updated formula in a column to last row ( 1048576) and saved it . Now i am trying to reset to actual end last row 1456 . While i am deleting row , excel gives me error saying that "Excel cannot complete the task with available resources. Choose...
  21. R

    VBA Array Code

    Hi Team, I need your help to provide a code which will check if there is an item # entered and nothing about its descriptions will pop up a Msg Box saying that specific Item # description is not entered , if there are Msg Box Saying There are multiple Items # with Description. The Array...
  22. R

    Format in Pivot table

    Hi Team, attached is a sample pivot table were I require a vba code which will automatically change the format of the field based on "hours" or Activity at its end. currently the pivot table keeps change back to its currency format if I select and deselect the Hours Field columns. all the...
  23. R

    multiple format in Pivot table

    Hi Team, I am looking for help in preserving the number format when pivot table is updated, in the attached file i hvae activity and hours , i need hours to be in general format and activity in currency format. I tried to by selecting preserve cell format on update but no luck. Appreciate...
  24. R

    With Statment with for loop

    Hi Team, Below is the code I am using with "FOR loop to concatenate the value in each row of column 2 ,3,4,5.which is taking long time as I have more than 25000 rows. while I have searched in google WITH Statement is something that I am thinking to sue to get the task done more quick. For...
  25. R

    Get the Last column Letter formula

    Hi , I am using sumif formula (=SUMIF($BD$15:$GW$15,$AV$15,$BD17:$GW17) , however in the current formula last column is GW , but when there is increase in range from GW to NI ,i need teh formula to get the rage updated to (=SUMIF($BD$15:$NI$15,$AV$15,$BD17:$NI17). Appreciate your help in...
Back
Top