One Last Query Question

  • Thread starter Thread starter carla 7
  • Start date Start date
C

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)
 
carla said:
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
Click to expand...

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)
Click to expand...

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

houghi
 
Back
Top