write to .txt file

[THECHAMP3343]

I am currently trying to build a file that will keep track of all completed work. I already have a spreadsheet for keeping track, however, I want to be able to clear the spreadsheet with the click of a button and write to a .txt file.

When the button is clicked, I would like for any cell appearing with "C" or "C/" to have its 5 corresponding row range(a8:e8, f6:j6, etc) to be cleared from excel and saved into a .txt file.

If this really isn't clear, I can provide my sample spreadsheet to give more of a visual to what I mean. Thank you.

 

[THECHAMP3343]

?

I am currently trying to build a file that will keep track of all completed work. I already have a spreadsheet for keeping track, however, I want to be able to clear the spreadsheet with the click of a button and write to a .txt file.

When the button is clicked, I would like for any cell appearing with "C" or "C/" to have its 5 corresponding row range(a8:e8, f6:j6, etc) to be cleared from excel and saved into a .txt file.

If this really isn't clear, I can provide my sample spreadsheet to give more of a visual to what I mean. Thank you.