Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
csv data into forms
I have 14 fields comma delimited data. There are 500 enteries of this
delimited data. Can I import the 14 fields onto mapped worksheet AND THEN save the file with a UniqueName of a field from the data... move to the next record....import it onto empty mapped worksheet... save it the new file with a UniqueName2 of a same field from the same data....move to the next recored...repeat For example... header1 is product number and are all unique... Can Excel import the data under header1 as filenames... |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
csv data into forms
See if this does what you want:
http://www.rondebruin.nl/copy1.htm HTH, Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "JBKAYAK" wrote: I have 14 fields comma delimited data. There are 500 enteries of this delimited data. Can I import the 14 fields onto mapped worksheet AND THEN save the file with a UniqueName of a field from the data... move to the next record....import it onto empty mapped worksheet... save it the new file with a UniqueName2 of a same field from the same data....move to the next recored...repeat For example... header1 is product number and are all unique... Can Excel import the data under header1 as filenames... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data collection - aggrating forms data ?? | Excel Discussion (Misc queries) | |||
Excel Data Entry Forms (Data, Worksheet) | Excel Discussion (Misc queries) | |||
Forms and Data | Excel Worksheet Functions | |||
Populating data on Forms from spreadsheet data | Excel Programming | |||
Data Valiation and Excel Data Forms | Excel Programming |