Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8
Default How to read CSV lines into different Worksheets depending on a date field?

Assume I have a EXCEL file with lets say 5 different worksheets labelled 2001,2002,2003,2004,2005
and a Comma separated text file containing number of lines with e.g. the following format
(notice the date in the third field!):

A,,21-07-2001,xxx,45432.34
HH,0,18-01-2004,kkk,453673.00
B,,08-09-2003,yyy,363.46
.....more lines.....

What I want to achieve now is to read this CSV file into the EXCEL file
AND to store each line into the refering Worksheet depending on the years part of the date
in the third field.

In other words the first line above should be stored into Worksheet named "2001",
the second line into Worksheet named "2004", ....

How do I do this in a smart way ?

Markus

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
Modify a calculated field formula depending upon selection of pagefield Tewari Excel Discussion (Misc queries) 0 April 10th 07 01:35 PM
draw different weight lines depending on the cell value birder1 Excel Discussion (Misc queries) 1 March 5th 07 10:53 PM
How to read CSV lines into different Worksheets depending on a date field? Markus Obermayer Excel Discussion (Misc queries) 0 February 8th 06 11:23 PM
How to read CSV lines into different Worksheets depending on a date field? Markus Obermayer Excel Worksheet Functions 0 February 8th 06 11:23 PM
How do i insert lines into a worksheet depending on if data exist. Nutter Excel Programming 0 February 9th 05 03:23 PM


All times are GMT +1. The time now is 04:03 PM.

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"