+ Reply to Thread
Results 1 to 2 of 2

Analyzing daa using VBA

  1. #1
    Registered User
    Join Date
    08-02-2016
    Location
    TN
    MS-Off Ver
    2013
    Posts
    1

    Analyzing daa using VBA

    so lets say i want to have an excel file read this

    lA l 2000 l
    where A is in one column and 2000 is in a different column
    i want excel to read the string in a, then from a list of limits i set to that string, spit out whether the value in the second column exceeds that value in a third column or another window
    how can i do that/ what commands are necessary?
    any help would be appreciated

  2. #2
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,049

    Re: Help with beginner excel programmer

    Does this have to be in VBA? I would wager you can use some excel formulas to do what you want, but we would need a sample workbook.

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    Last edited by mikeTRON; 08-02-2016 at 05:58 PM.
    Please ensure you mark your thread as Solved once it is. Click here to see how.
    If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Analyzing #N/A in the output
    By macrolearnerkk in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-02-2015, 10:30 AM
  2. Analyzing Data
    By wildwestarena in forum Excel General
    Replies: 28
    Last Post: 05-11-2015, 08:17 PM
  3. analyzing formula
    By amartino44 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-17-2013, 07:31 PM
  4. Help analyzing my data.
    By Shindel in forum Excel General
    Replies: 6
    Last Post: 06-03-2011, 06:06 PM
  5. Data analyzing
    By NTB in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-02-2010, 12:06 AM
  6. Analyzing values
    By maheshg in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-31-2010, 11:58 PM
  7. Excel 2007 : analyzing xy coordinates
    By someguy85 in forum Excel General
    Replies: 0
    Last Post: 01-21-2010, 05:15 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1