How would I save excel data to an existing .txt file

[Sir Dude]

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

1bb4ae.png

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)

23222e.png

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

[FlameRetired]

Sir Dude,

Welcome to the forum.

Many of us do not have the capability of seeing *.png files....me included. Also it is helpful if you can upload a small sample Excel workbook file that illustrates your question with sensitive data removed. It saves us having to retype your data.

Regards,
FR

[Sir Dude]

Sorry, I did not know. I attached the 2 files that I am using. The Spreadsheet and .txt file

[newdoverman]

The macro attached to the C in column T doesn't copy the row, it clears it. If you select from A4:Q4 and copy then go to the TXT file you can paste the values at the end of the file without problem.

I recorded a macro and created a button for it to select the row and copy it....this is what you need for the rest of the rows.

[FlameRetired]

If I understand correctly you are wanting to append new data to an existing text file using a macro.

Unfortunately I do not know how to do this in VBA. Stay with your thread.....somebody knows. The remaining question @ reading the numeric value and what to do with it might also be settled then, too.

Sorry I couldn't help.

[Sir Dude]

The macro attached to the C in column T doesn't copy the row, it clears it. If you select from A4:Q4 and copy then go to the TXT file you can paste the values at the end of the file without problem.

I recorded a macro and created a button for it to select the row and copy it....this is what you need for the rest of the rows.

Yes, I know. I was going to add that function. I know how to to make that function it is the copying the text to an existing .txt file. To keep as a log file. I can copy the data, but it copies over existing data so I lose what I had before. I was going to make it a multi function button. I was going to have it
1. Copy the data from the row.
2. Open a .txt file then paste the data to the text file below existing data then save, and close the .txt file.
3.Then it was going to clear the row.

Then the sort button above moves everything up in order.

If I add columns it messes with other macros I have in place. Thank you for trying tho. I appreciate your time.