I need help creating a macro/vbscript to take data from a worksheet and convert it into a csv file. So I have the following data file format in Excel.
With the example above, there are some accounts I don't want to carry over to this csv file format as well as anything without a dash.
My output format, only pull account "500-40" and account "491-20" since I am filtering with account that does not have a dash or the account "3909-20".
Can someone help with an example? Let me specify in the VBScript which account(s) to not carry into the CSV file as well as any account without a dash?