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
Using a date field in mail merge triciaodd Excel Discussion (Misc queries) 0 January 26th 06 01:48 PM
Date & Time Field Diane Walker Excel Discussion (Misc queries) 2 January 10th 06 03:30 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
Compare 2 Worksheets Create a 3rd depending on results Kevin Excel Discussion (Misc queries) 1 February 4th 05 11:49 PM


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