Hello,
I am looking for some help with some code that I don't know how to compile. I know literally nothing about VBA and am working my way through forums.
The scenario: I am merging worksheets from multiple workbooks into a single location. I am then filtering the data and am left with 2 columns on each worksheet (each sheet is labelled with a unique patient ID). I am left with column H as the "Nuc Change" and column L as the "Hint" in each worksheet. The format of column H is "X -> Y (z)" and I am trying to extract X, Y, and z into 3 columns. The caveat is that if "Hint" says not detected, then Y=X in this case. As well as if the third column reads "****" this indicates the allele is actually a Y,Y. These then need to be converted into a numerical code that reads as follows. X, X = 1, X, Y = 2, Y, Y = 3. This is then concatenated into 1 cell to form a unique ID. Is something like this even possible? I know it is quite complicated and I'm not sure where to begin. I have code for the merging of files, formatting and hiding unused columns but am stuck on just about the rest. I am using a Left Function with detection of last row but keep getting errors so cant move forward. Any help is appreciated. Honest feedback on whether this is doable is also appreciated.
I am looking for some help with some code that I don't know how to compile. I know literally nothing about VBA and am working my way through forums.
The scenario: I am merging worksheets from multiple workbooks into a single location. I am then filtering the data and am left with 2 columns on each worksheet (each sheet is labelled with a unique patient ID). I am left with column H as the "Nuc Change" and column L as the "Hint" in each worksheet. The format of column H is "X -> Y (z)" and I am trying to extract X, Y, and z into 3 columns. The caveat is that if "Hint" says not detected, then Y=X in this case. As well as if the third column reads "****" this indicates the allele is actually a Y,Y. These then need to be converted into a numerical code that reads as follows. X, X = 1, X, Y = 2, Y, Y = 3. This is then concatenated into 1 cell to form a unique ID. Is something like this even possible? I know it is quite complicated and I'm not sure where to begin. I have code for the merging of files, formatting and hiding unused columns but am stuck on just about the rest. I am using a Left Function with detection of last row but keep getting errors so cant move forward. Any help is appreciated. Honest feedback on whether this is doable is also appreciated.