Sorting
Hi Everyone
New on this Forum
Sure that this kind of stuff have been already... I apologize...
I was on XP Office 2003 and Macro Excel 4
Laptop died... Now W7 Office 2010 and starting to learn VBA...
Datas
Date................Name.............Results
01/02/2012......Jean...............10
01/02/2012.......Paul...............5
01/02/2012.......Jean..............-5
01/02/2012.......Pierre............-5
O2/02/2012.......Jean.............-5
02/02/2012.......Pierre............10
etc
My problem : sort that datas (up to 1000 lines !)
By date
01/02/2012... Negative.... Positive.... Net.... Ratio(Pos/Neg)
02/02/2012...
By name
Jean.............. Negative.... Positive.... Net.... Ratio (Pos/Neg)
Pierre....
And the VBA code to do that...
Thanks Everyone
B
(this site is amazing but so hudge... that it is difficult to find something)
PS I already tried Pivot Table : I can't insert =0 or =0 inside Pivot to have a column for negative values /positive values
Last edited by bert505 : April 9th 12 at 03:43 PM
Reason: More...
|