michael168
Member
I need VBA helps for the summary report from sheet 1 to sheet 2 horizontally in 2 columns.
Presently I use the auto filter method which cannot produce something as in sheet 2. I wish to look the report at a glance.
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.this is the 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, .........
The value in col B read from Sheet 1 where Col A = Sheet 2 Col A from bottom up.It record the counting from last row and continue until skipping -200 rows of datas.
Thanks
Michael
Presently I use the auto filter method which cannot produce something as in sheet 2. I wish to look the report at a glance.
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.this is the 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, .........
The value in col B read from Sheet 1 where Col A = Sheet 2 Col A from bottom up.It record the counting from last row and continue until skipping -200 rows of datas.
Thanks
Michael