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

    Workbook error code 1004.

    Hi, I've been using the same workbook code for years without trouble. recently the macro in the workbook begain throwing the error code 1004. Run Time Error ‘1004’: Unable to get the vlookup property of the WorksheetFunction class The code is below. Please help me sort it out. Sub...
  2. T

    need VB code to send email message based upon sheet criteria

    Greetings, I have a rather elaborate workbook that tracks client satisfaction surveys. My support managers need to follow up on each survey with negative responses. I need a block of code that will do the following upon closing the workbook: 1) search Column "N" for any rows that do NOT...
  3. T

    Need help using VBA to insert a formula

    I need to edit the VBA code below to insert the following formula into my sheet: Formula =IF(COUNTIF($A148:$R148,"Unsatisfied")>0,"X",IF(COUNTIF($A148:$R148,"Very Unsatisfied")>0,"X","")) I am trying to add the formula as the value for the...
  4. T

    Need to create a pop-up to display data from another sheet

    Hello All, I want to create a pop up window that activates when users select a specific field From a range on Sheet3; Range(A1:A100). When active, the pop-up will display data from another sheet(Sheet2). What I need to do is create a lookup that matches the value of cell A1 on Sheet3 to...
  5. T

    How Do I set up a data connection to only update data once per day?

    Greetings, I have a workbook that I modify daily. After I modify the workbook, my team reviews the results. The workbook (Survey Results) has a data connection that draws in data from an external source (Additional Data)on our intranet. Since Additional Data is only updated once each day at...
  6. T

    Need VBA to scan dates of entries, and change adjacent cells

    I am preparing a sheet to track client survey responses. My company calls back any client who submits a negative survey response. My goal is to write code that will (upon opening the workbook) scan the submit date of all surveys, and then set the survey status to "Expired" if the survey is over...
Back
Top