One Last Query Question

[carla 7]

Ok, this is my final plea for help. In my workbook, all worksheets are
formatted the same. What I seek is a macro which copies a range, say B2:B8,
in each worksheet, and places the values for each worksheet in the last
worksheet of that workbook. However, the values should be HORIZONtALLY
pasted next to each other.

Thanks Tremendously

(PS: All the more fantastic if the values could be pasted to a new workbook)

 

[houghi]

Ok, this is my final plea for help. In my workbook, all worksheets are
formatted the same. What I seek is a macro which copies a range, say B2:B8,
in each worksheet, and places the values for each worksheet in the last
worksheet of that workbook. However, the values should be HORIZONtALLY
pasted next to each other.

Thanks Tremendously

You need transpose. I just recorded the following macro. You can do the
same with al others:
Sub Macro1()
'
' Macro1 Macro
' Macro recorded 31/07/2008 by houghi
'
Range("B2:B8").Select
Selection.Copy
Sheets("Sheet2").Select
Range("B2").Select
Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone,
SkipBlanks:= _
False, Transpose:=True
End Sub

(PS: All the more fantastic if the values could be pasted to a new workbook)

This can bee done as well adn I leave that as an excesise for others.

houghi