copy range on every worksheet (diff names) to a master worksheet (to be created)

[Bernie]

Any ideas??

I need to copy a range (same location) on every worksheet (diff names
to a master worksheet (to be created).
I also need this range to be pasted special (transform) so the range o
4-5 cells is horizontal for a mailmerge instead of vertical.

Please help??!! :confused

 

[Ron de Bruin]

Hi Bernie

http://www.rondebruin.nl/copy2.htm

You can use PasteSpecial to transpose

 

[Tom Ogilvy]

Why " "

did you try doing it with the macro recorder turned on and then couldn't
understand the results.

Range("B3:E12").Select
Selection.Copy
Sheets("Sheet2").Select
Range("C4").Select
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:=
_
False, Transpose:=True

What part is confusing?

You don't know how to generalize it and copy progressively.