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

Hi
really not sure how you derived your values. Could you explain the
logic behind your calculation?

--
Regards
Frank Kabel
Frankfurt, Germany


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

Presently I use the auto filter method which cannot produce something
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 from
bottom up.It record the counting from last row and continue until
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
are
equal else the value will becomes negative.

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


Thanks
Michael


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

Hi! Frank Kabel,
First of all I wish to thank you for trying to help me. I try t
explain the logic as clear as possible and hopefully you can get th
idea behind.

In sheet 2, Col A contain the unrepeated value which can be found i
col A of sheet 1. In sheet 2, col B values were derived from col B o
sheet 1 appearing and skipping or in another word the gaps in between.

Refer to my post, you can see them more clearly.

Frank Kabel wrote:
*Hi
really not sure how you derived your values. Could you explain the
logic behind your calculation?

--
Regards
Frank Kabel
Frankfurt, Germany


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

Presently I use the auto filter method which cannot produc
something
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
from
bottom up.It record the counting from last row and continue until
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
are
equal else the value will becomes negative.

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


Thanks
Michael


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

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

Hi
I had a look at your post :-)
But for example your first value is derived by the formula
2010-2010+1
why add '1' in this case. Your calculation just does not seem
consistent for me (but that's probably just me). So you may explain
this logic with some more detail.

--
Regards
Frank Kabel
Frankfurt, Germany


Hi! Frank Kabel,
First of all I wish to thank you for trying to help me. I try to
explain the logic as clear as possible and hopefully you can get the
idea behind.

In sheet 2, Col A contain the unrepeated value which can be found in
col A of sheet 1. In sheet 2, col B values were derived from col B of
sheet 1 appearing and skipping or in another word the gaps in
between.

Refer to my post, you can see them more clearly.

Frank Kabel wrote:
*Hi
really not sure how you derived your values. Could you explain the
logic behind your calculation?

--
Regards
Frank Kabel
Frankfurt, Germany


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

Presently I use the auto filter method which cannot produce
something 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
from bottom up.It record the counting from last row and continue
until 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
are equal else the value will becomes negative.

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


Thanks
Michael


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


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

Hi ! Frank Kabel,
I add 1 to 2010 because the last draw no in this example is 2010.
need a 1 as the first starting value,that's why I use the 2010-2010+
to give me a value of 1.

So if you take a look at the example below you will understand what
mean.

e.g. Sheet 2 (Report)
Col A===Col B
A=== 1,-5,1,-2,2 .......

The value will add 1 to the current value if the next value of col A i
the same.

Thanks
Michael.

Frank Kabel wrote:
*Hi
I had a look at your post :-)
But for example your first value is derived by the formula
2010-2010+1
why add '1' in this case. Your calculation just does not seem
consistent for me (but that's probably just me). So you may explain
this logic with some more detail.

--
Regards
Frank Kabel
Frankfurt, Germany


Hi! Frank Kabel,
First of all I wish to thank you for trying to help me. I try to
explain the logic as clear as possible and hopefully you can ge
the
idea behind.

In sheet 2, Col A contain the unrepeated value which can be foun
in
col A of sheet 1. In sheet 2, col B values were derived from col
of
sheet 1 appearing and skipping or in another word the gaps in
between.

Refer to my post, you can see them more clearly.

Frank Kabel wrote:
*Hi
really not sure how you derived your values. Could you explai
the
logic behind your calculation?

--
Regards
Frank Kabel
Frankfurt, Germany


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

Presently I use the auto filter method which cannot produce
something 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
from bottom up.It record the counting from last row and continue
until 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 & shee
2
are equal else the value will becomes negative.

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


Thanks
Michael


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


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

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

Hi Michael
sorry to say but this is the same example I didn't get in the first
place. So it's probably me who did not see the logic behind it. Maybe
someone else sees the algorithmn

--
Regards
Frank Kabel
Frankfurt, Germany


Hi ! Frank Kabel,
I add 1 to 2010 because the last draw no in this example is 2010. I
need a 1 as the first starting value,that's why I use the 2010-2010+1
to give me a value of 1.

So if you take a look at the example below you will understand what I
mean.

e.g. Sheet 2 (Report)
Col A===Col B
A=== 1,-5,1,-2,2 .......

The value will add 1 to the current value if the next value of col A
is the same.

Thanks
Michael.

Frank Kabel wrote:
*Hi
I had a look at your post :-)
But for example your first value is derived by the formula
2010-2010+1
why add '1' in this case. Your calculation just does not seem
consistent for me (but that's probably just me). So you may explain
this logic with some more detail.

--
Regards
Frank Kabel
Frankfurt, Germany


Hi! Frank Kabel,
First of all I wish to thank you for trying to help me. I try to
explain the logic as clear as possible and hopefully you can get
the
idea behind.

In sheet 2, Col A contain the unrepeated value which can be found
in
col A of sheet 1. In sheet 2, col B values were derived from col B
of sheet 1 appearing and skipping or in another word the gaps in
between.

Refer to my post, you can see them more clearly.

Frank Kabel wrote:
*Hi
really not sure how you derived your values. Could you explain the
logic behind your calculation?

--
Regards
Frank Kabel
Frankfurt, Germany


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

Presently I use the auto filter method which cannot produce
something 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
from bottom up.It record the counting from last row and continue
until 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
are equal else the value will becomes negative.

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


Thanks
Michael


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


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


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