I've been working with the following script to take a series of .csv files and combine them into one .xls workbook utilizing Excel 2007. It works great but the problem is that all of the headers in the series are the same. How may I modify this script to include the headers on...
I need a formula that will tell me the average price (from Column "Q") and omit any "$0.00" or Blanks.
Even better, a formula that will allow me to enter the amount that will be omitted. (Example: anything less than $5.02 will be omitted) :banghead: