|Hi and thanks in advance for any help you can provide. |
I have a spreadsheet that currently populates data in column (AG) if the IF statements are true. Could be as few as 2-3 rows and up to as much as 4000 rows. I would like help in creating a button activated macro that can find all cells within the (AG) column that contains any data and then save that to a Text (Tab Delimited) file with the information separated by a pipe "|".
Some additional requests would be to automatically save the tab delimited file to be what the original excel document name is then append it with the current date.
Ex: original excel spreadsheet name is "Expenses.xls"
Automatically saves it as "Expenses_YYYYMMDD.txt" with the abiliity to save the file to a local disk or file share.