View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Earl Kiosterud Earl Kiosterud is offline
external usenet poster
 
Posts: 611
Default compile data from CSV

Benjamin,

You can either open it (File - Open, changing the File Type box to csv, txt, whatever it
is), or import it (Data - Get External Data). There's a blurb on reading text files at
http://www.smokeylake.com/excel/textfiles.htm.

--
Regards from Virginia Beach,

Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"Benjamin" wrote in message
...
I export data from an inventory program creating a CSV file showing part#,
qty, price, etc. on a daily basis. I am looking to compile the data into
another sheet with data showing each day: date, part#, qty, price, etc.
Ideally, I would like each part number on it's own sheet, listed by date.
Could someone point me i the right direction in getting the data from the
daily exported CSV into a another worksheet?

TIA