Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 44
Default Transfer data as per there date in there month.

I export out standing statement file from other prg. to excel. data export
like date, supply no., and o/s amt.
I want to transfer o/s amount month wise next to data as per there month
columns.
Like e.g.
First 3 columns are export.
80020 36362 56890
Date Supply No. o/s Amt Jan Feb March April Like Up to Dec
1-jan-06 A23456 45900 45900
12-jan-06 D67890 34120 34120
02-feb-06 E34679 23784 23784
17-feb-06 R4567 12578 12578
21-mar-06 N5466 56890 56890
Any help.

Thanks in advance
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
Formula to transfer and add data with date. Scott Marcus Excel Discussion (Misc queries) 0 October 27th 06 03:33 PM
Sort month/date/year data using month and date only SMW820 Excel Discussion (Misc queries) 6 June 22nd 06 05:14 PM
Transfer data relevent to date KandK Excel Discussion (Misc queries) 7 May 1st 06 08:00 AM
Transfer data relevent to date KandK Excel Worksheet Functions 1 April 23rd 06 12:13 PM
transfer cell $ amount to other sheet month-to-month without overc Colin2u Excel Discussion (Misc queries) 1 July 28th 05 02:36 AM


All times are GMT +1. The time now is 12:37 PM.

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

About Us

"It's about Microsoft Excel"