LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kay Kay is offline
external usenet poster
 
Posts: 129
Default Seperate values and put it in different rows in different sheet

I have these columns
CustomerID, #of orders , StartDate, End date
111 6 10/1/2008 12/1/2008
112 4 10/1/2008 10/30/2008

So i get months 10,11,12 (also i am working on this)
I want this (as i want #of orders for each month)
in other sheet I want
Month # of orders
12 2
11 2
10 6 (4+2 = 6)

How can I do this using macro?

Thanks!

 
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
How to name many rows by values in a column on the same sheet at o Dima Excel Discussion (Misc queries) 11 August 13th 08 07:42 AM
How to name many rows by values in a column on the same sheet at o Dima Excel Worksheet Functions 8 August 13th 08 07:42 AM
Paste Values in Number of rows as count in other sheet Salman Excel Discussion (Misc queries) 0 February 27th 07 06:04 AM
How to seperate 2 values to 2 different cells nander Excel Discussion (Misc queries) 2 April 27th 06 08:06 PM
How can I look up two seperate values/cells and return the value . Barbara Excel Worksheet Functions 2 December 6th 04 09:59 PM


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