I have a delimted text file that I need to import into excel sort it by
product number and total sales by product. I have to do this twice a month so
I made a marco that imports the file and then using filter it filters by
product number and copies the resuts to another sheet in the workbook.

The trouble Im having is that I don't know how to add the entire column for
total sales automatically. the total sales will always be in column C but the
row number will always be different.

I have tried highlighting the C column and clicking on the sum icon in the
toolbar but it doesn't give me a total at the bottm of the column.

Is there a way to have excel give me the sum at the bottom of the column if
the row number is different everytime?

Thanks