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
Markus Obermayer
 
Posts: n/a
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
formating a date field Stephen Excel Discussion (Misc queries) 3 January 25th 06 08:33 PM
How do I "extract" birthyear from a date field? cp Excel Discussion (Misc queries) 2 December 2nd 05 04:30 PM
#NUM! in Date field calculation Rick Excel Worksheet Functions 4 November 29th 05 09:31 PM
Capturing a date field once only Rob Svilts Excel Worksheet Functions 2 October 27th 05 01:22 PM
Syntax Error in Excel Query for DATE field James T Excel Discussion (Misc queries) 3 August 31st 05 12:33 PM


All times are GMT +1. The time now is 10:19 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"