Thread: copy range on every worksheet (diff names) to a master worksheet (to be created)
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default 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??!!


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