Horizontal Report

M

Michael168

I need helps for the summary report from sheet 1 to sheet 2 horizontall
in 2 columns.

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 -200 rows of datas.

Thanks
Michae
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

A For Each in Range... with a .Find(what:="TJ", ... in it problem 15
Copy Application.Union(c.Offset(0, 1), c.Offset(0, 2)... to a list onsame & another sheet 27
Summary display horizontally 13
Macro deleting rows based in main sheet on values in another sheet 5
Loop thru xx No. of sheets until the four strValue combo's are found 6
Transpose & reorg data from 2 WS to new WB 2
Resize a row but copy but skip columns I don't want to copy 6
compare column color row 2

Top