Results 1 to 3 of 3

Thread: Extracting range of data by prompting user for values

  1. #1

    Thread Starter
    Junior Member
    Join Date
    May 2013
    Posts
    17

    Extracting range of data by prompting user for values

    I have a large amount of data in a txt file that I have successfully imported to excel via visual basic. This is multiple columns and rows (Column A is phase, B is temperature, and C is result). How can I write a macro that prompts the user to enter the range of phase and temp they want to look at (ie: 2.35-4.75 for a the range of cells that cover from phase 2 at temp 35degC to phase 4 at temp 75 degrees) and have it extract that data to store separately/graph? So the user doesn't have to scroll through a huge amount of data to plot manually. Thank you!

    Example of a smaller scal code:
    Phase Temp Result
    1 34 99
    1 38 97
    1 44 107
    2 44 100
    2 56 105
    3 64 110
    4 69 113
    4 72 115

    So for example have the user input a range of 1.44 to 3.64 and the macro will find the range of those cells and plot temp for result.
    Thank you!

  2. #2
    PowerPoster SamOscarBrown's Avatar
    Join Date
    Aug 2012
    Location
    NC, USA
    Posts
    9,622

    Re: Extracting range of data by prompting user for values

    Morning TTC.....this is really an issue for the Excel Fora. You can do it through VB6, but you are asking for a Macro....

  3. #3
    Banned
    Join Date
    Nov 2012
    Posts
    1,171

    Re: Extracting range of data by prompting user for values

    post like these gives me head akes

Posting Permissions

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



Click Here to Expand Forum to Full Width