Search:

Type: Posts; User: jrosen12; Keyword(s):

Search: Search took 0.00 seconds.

  1. Creating a macro that returns results of a SQL query

    Hello,

    I am new to VBA and I am looking to create a macro that connects to database "REPT" and returns distinct values for columns "sub_id" and "term_date" where the value in "plan_code" column is...
  2. Replies
    1
    Views
    211

    Parse text with a keyword "else"

    Hi,

    I am trying to parse a string beginning at the word "else" and ending at a number.

    if(LowIncomeSubsidyLevel = 1) then 27.00 else (if(LowIncomeSubsidyLevel=0.75) then 33.40 else (if(...
  3. Replies
    7
    Views
    651

    Re: Copy/paste VBA code

    Worked perfectly! Thank you
  4. Replies
    7
    Views
    651

    Re: Copy/paste VBA code

    Thank you for your help. I think manually would be best, by clicking a button that has the macro assigned to it.
  5. Replies
    7
    Views
    651

    Re: Copy/paste VBA code

    There may be a better way of getting at what I want, but my end goal is that the values in column E on "Values" will have a corresponding value for its row.

    G9 on "GL" is a vlookup formula based...
  6. Replies
    7
    Views
    651

    Copy/paste VBA code

    Hello,

    I am a beginner (new learner) of VBA. I am trying to create a macro that does the following:
    The user will be on sheet "Values" He/she will type in three values in columns A, B, and C. I...
  7. VBA code to delete rows based off of criteria in a column

    Hello,

    I am looking for a code that searches worksheet called Checks_Export in Column B, and any rows that DOES NOT have BHP in Column B are deleted

    Thank you!
Results 1 to 7 of 7