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

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

--
Berni
-----------------------------------------------------------------------
Bernie's Profile: http://www.excelforum.com/member.php...fo&userid=1457
View this thread: http://www.excelforum.com/showthread.php?threadid=26236

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

Hi Bernie

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

You can use PasteSpecial to transpose

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Bernie" wrote in message ...

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 of
4-5 cells is horizontal for a mailmerge instead of vertical.

Please help??!! :confused:


--
Bernie
------------------------------------------------------------------------
Bernie's Profile: http://www.excelforum.com/member.php...o&userid=14571
View this thread: http://www.excelforum.com/showthread...hreadid=262361

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

Why " :confused:"

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.

--
Regards,
Tom Ogilvy

"Bernie" wrote in message
...

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 of
4-5 cells is horizontal for a mailmerge instead of vertical.

Please help??!! :confused:


--
Bernie
------------------------------------------------------------------------
Bernie's Profile:
http://www.excelforum.com/member.php...o&userid=14571
View this thread: http://www.excelforum.com/showthread...hreadid=262361