Results 1 to 34 of 34

Specified search function that selects all data in that row

Threaded View

  1. #1
    Registered User
    Join Date
    03-11-2015
    Location
    the dirty south
    MS-Off Ver
    Ms office 2011
    Posts
    36

    Specified search function that selects all data in that row

    Hi guys

    Let me preface this by saying I'm new to Vba and there's been a learning curve so please pardon my ignorance. I've been looking through the forums and I haven't seen a problem like mine, but please feel free to let me know if the solution to my question exists out there.

    The problem:
    So I have an experiment I've been running and our instruments outputs the data into excel. What I would like to do is that I want to take this data that comes from a separate excel sheet and place it into a new excel sheet and have each row of data that contains the particular genotype I am looking at separated out into different columns that can be analyzed. So I was thinking about a message box that was allow you to insert the the number of genotypes, because it can vary per experiment, and a search function that can look for key words such as "wildtype" and take that data and have it inserted into a specific column, ect. The search would also have to be not specific as capitalization can vary.

    The attempt:
    So I was able to figure out the importation of the data from another sheet but I am lost how to do the search box as described above.
    heres what I have so far:

    Sub Time_Zones()
       'Messagebox
    Call MsgBox("Note: Please select data inputs from Ethovision for each computer repectively. All data will be displayed on Sheet2", vbOKOnly, "Welcome")
        Dim SaveDriveDir As String, MyPath As String
        Dim FName As Variant
    
        SaveDriveDir = CurDir
        MyPath = Application.DefaultFilePath    'or use "C:\Data"
        ChDrive MyPath
        ChDir MyPath
        FName = Application.GetOpenFilename(filefilter:="Excel Files, *.xl*")
    
        If FName = False Then
            'do nothing
        Else
        GetData FName, "Analysis", Range("C:C")
        
        
    End Sub
    ^^^
    this is just for the importation of the data.

    I really appreciate all the help you guys can give on this.
    Also as an aside if you could explain how any of the code works I would appreciate it as i find it helpful to learn
    Thank you guys again!
    Last edited by novious1; 03-28-2015 at 04:50 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 7
    Last Post: 06-07-2014, 06:35 PM
  2. [SOLVED] Input Box User Selects Data
    By basketball2524 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 12-21-2013, 06:46 PM
  3. Drop Down Box Choice Selects Volume Function
    By Tony Pass in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-29-2013, 01:40 AM
  4. help. Search based on text input in a column selects a row and copies data.
    By ridermarangoni in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-27-2012, 10:53 AM
  5. Code selects entire rows upto one range and same code selects only columns for other.
    By sriharigk in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-09-2012, 05:19 AM

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