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!
Bookmarks