I need helps for the summary from sheet 1 to sheet 2 to be displa
horizontally so that I view them all at a glance. The macro will alway
execute from last row upward for the next 100 rows.

Presently I use the auto filter method which cannot produce somethin
as in sheet 2.

Can it be done ? Kindly take a look at the example below.

Sheet 1 (Datas)
Rows===Col A

0001 A

until

2000 A
2001 A
2002 C
2003 B
2004 A
2005 B
2006 B
2007 C
2008 C
2009 C
2010 A (e.g.last row)

Sheet 2 (Report)
Col A===Col B

A 1,-5,1,-2,2 .......
B -4,2,-1,1 .........
C -1,3,-4,1,-2 ......

The value in col B read from Sheet 1 where Col A = Sheet 2 Col A fro
bottom up.It record the counting from last row and continue unti
skipping -100 rows of datas.
e.g. the sheet 2 col B values were from row no 2010-2010+1=1,
2010-2005=-5,2005-2004=1,2004-2002=-2,2002-2000=2.
The value in col B is positive when columns A of sheet 1 & sheet 2 ar
equal else the value will becomes negative.

I hope I can make it clear for someone to help me.


Thanks
Michae

--
Message posted from http://www.ExcelForum.com