Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() Hello again everyone, I have a new file I am working with this time. This one I need to extract data from a .csv file into an Excel file, and rearrange the data to make it appear a certin way. Esentially the .csv file has sample data listed in rows with Sample Type, Method Type, Compound Name, Measurement Units, and Results as the columns. A programmer no longer with the company created a mini-program that takes these columns and rows and rearranges them so that the compund Name and units becomes the column header, and the results are reported in rows below with row headers of the sample type. I am trying to create a macro that will duplicate this result. I don't even know where to begin. I haven't done anything like this before, and I am so lost I don't even know how to start researching what I want to do. Do to being as lost as I am, I don't have any code started. Any advice or guidence will be appreciated. Here's to hope, Amber:) -- Amber_D_Laws ------------------------------------------------------------------------ Amber_D_Laws's Profile: http://www.excelforum.com/member.php...o&userid=30012 View this thread: http://www.excelforum.com/showthread...hreadid=504986 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
AppleWorks file conversion to Excel file | Excel Discussion (Misc queries) | |||
xlw. file conversion | Excel Discussion (Misc queries) | |||
old xls file conversion | Setting up and Configuration of Excel | |||
MAC file conversion | Excel Discussion (Misc queries) | |||
PDF FILE CONVERSION | Excel Programming |