I need to take data from a simple spreadsheet and save it to an existing .txt file. I have tried but It always over writes the data that was there before. Below is the spreadsheet



I need to be able to Click on the "C" in the last column which will select that one row (example Line 4) and save the data in each cell and copy it to my text file in the same folder. The text will look something like this. (The data is a screenshot from another try that is why it doesn't match, just in case you were wondering lol)


I also need the last cell to read the numerical value. Is there a macro code that can do this? Like I said I cannot get it to save to a following line in the text file. It just over writes the last save line of text. This has been driving my noob brain crazy. I would appreciate any help you can share. Thank you for your time.

Sir Dude