that's fine to get the data but how do I get the totals? the wizard only allows for column totals. obviously i am missing something.
I really appreciate the advice
Sounds good but the data>import external data>import option is not available in excel 2007. Apparently there are quite a few differences from previous versions.
And, yes, the name of the files are different every time.
I like the idea of using import. Any idea how to get there in 2007?
I need help. I have .txt files sent to me routinely and I am trying to write vba to rename columns, rows, add calculated columns, page breaks, etc.
So far, I have been able to do all that but I am having trouble with worksheetfunctions that need to reference relative cells.
here's what I am...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.