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

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" <(E-Mail Removed)> wrote in message
news:CC276A37-767C-4769-BE2D-(E-Mail Removed)...
>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