Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,836
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Data collection - aggrating forms data ?? InOverMyHead Excel Discussion (Misc queries) 2 May 27th 09 07:23 PM
Excel Data Entry Forms (Data, Worksheet) No Name Excel Discussion (Misc queries) 1 June 28th 07 10:12 PM
Forms and Data Dinky Excel Worksheet Functions 1 September 12th 06 01:57 PM
Populating data on Forms from spreadsheet data Kristen[_6_] Excel Programming 3 April 13th 06 07:29 AM
Data Valiation and Excel Data Forms Marianne Excel Programming 1 August 3rd 05 03:30 PM


All times are GMT +1. The time now is 08:44 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"