VBA to create new file

I am trying to create a VBA that will do the below 5 steps, but I am not sure how or if it is possible.

1. Copy the column headers from Sheet 1 to Sheet 2
2. Only show if column E = benign, likely benign, VUS, VUS confirmation, pathogenic, likely pathogenic (the rows in E may be variable, but E will always contain the values listed)
3. In column G of sheet 2 combine refseq# and Sanger up until ; (semi-colon)
4. If there is a / in column B (Sanger), then whatever letter is opposite text in front of the > symbol is used
c.828-17G>A
c.159C>G
c.2339A>C
5. column G is saved to a text file called Sanger

I have attached a workbook where sheet 1 is the input and sheet 2 is the output, before column G is saved in a text file.

Thank you.

Sorry, I attached it.

Thank you, I will wait for the modified code before downloading... have a nice weekend.

Thank you all very much.

The headers are not necessary. Is it possible to save the sheet2.column G output (from the first variant to the last) to C:\Users\cmccabe\Desktop\Sanger in a file called Sanger.txt? Thank you .


Sanger.txt
NM_000744.6:c.1209G>T
NM_000744.6:c.1227T>C
NM_001909.4:c.828-17G>A
NM_005670.3:c.159C>G
NM_172107.2:c.2339A>C
NM_018129.3:c.165C>T
NM_001165963.1:c.1212A>G
NM_001165963.1:c.3199 G>A
NM_021007.2:c.4914T>A
NM_000744.6:c.639T>C
NM_000744.6:c.678T>C
NM_006950.3:c.1321G>T
NM_000744.6:c.1209G>T

Is it possible to automatically send the newly created text file to: https://mutalyzer.nl/batchPositionConverter havethe build be hg19, the email: [email protected], and the file is the text file. Then click submit. I attached a screenshot of the page. Thank you.

Thank you very much for your help. I will start another thread, but have attached the input (Sanger.txt) and the final result (Results_141123889088.txt). I use chrome to access the site. Thanks again .

Hello,

I am having trouble solving these two issues and wanted to ask for your expert help. Thank you .

1. whatever the first item is is repeated twice in the text file (in the attached sanger.txt it is NM_000744.6:c.1209G>T - row 9 in the xlsm)
2. in the NGS_Sanger.xlsm row 61 (c.863+2_863+3insT) does not show up in the text file (I think because the > is not found)

Thank you .

The majority of the time the data will look like this: c.1209G>T

and sometimes included with that data is data in this format: c.863+2_863+3insT, both need to be copied over to the text file. The first case works great.


Thanks .

Hi,

column F:column B

NM_152778.2:c.863+2_863+3insT

Does this help? Thank you

I added some lines of code as it could be a + or -, but the new lines are not correct (I underlined them) as no text file results. Also, the first variant that is copied to the text file is always duplicated at the start and then again at the end. Thank you for all your help .

Please Login or Register  to view this content.

This varient c.863+2_863+3insT is copied, but this variant c.2508-34delG is not copied. Its possible that either could be on the data. Thanks .

I just got around to trying out the code, it works great.... thank you . The first variant, no matter what it is, always repeats but thats not a big deal. Thanks again .

Heres an example output:

Please Login or Register  to view this content.

Hi,
The code is below and the first record in the spreadsheet also gets repeated. I attached 3 examples. Thanks .

VB

Please Login or Register  to view this content.

That fixed it.... thank you .

I have being working on trying to make the newly created text file a name that the user inputs. So when they click on yes at the opening prompt they enter a name.

Please Login or Register  to view this content.

The line in the Write2Text that defines the file is:

Please Login or Register  to view this content.

So lets say the name Smith,Jordan was entered in order for the text file to be named that would:

Please Login or Register  to view this content.

work?

Thank you .

Thank you .

In the attached sheet (NGS_Sanger) in the Sanger column , the data can look like:

c.165C>T; p.S55S
c.1212A>A/G; p.V404V
c.3199 G>G/A; p.A1067T

The code below does a variety of things, as you no doubt remember, but is it possible to add a line that if the data in the column is in the format 1 then “hom” if the data is in the format 2 or 3 then “het” is outputted to Sanger.txt? Basically, if there is a ..>../.. then “het”, but if ..>.. the “hom”. Thank you very much . The output as is right now is also attached (Sanger.txt). Thank you.

Desired Sanger.txt output
NM_000744.6:c.1209G>T hom
NM_000744.6:c.1227T>C het
NM_005670.3:c.159C>G het

Please Login or Register  to view this content.