Thread: copy range on every worksheet (diff names) to a master worksheet (to be created)
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 27,285
Default copy range on every worksheet (diff names) to a master worksheet (to be created)
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.

--
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??!!


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



Reply With QuoteReply With Quote