Thread: How to copy from sheet1 then paste special transpose to sheet2,3,4
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
stanleydgromjr[_9_] stanleydgromjr[_9_] is offline
external usenet poster
  
Posts: 1
Default How to copy from sheet1 then paste special transpose to sheet2,3,4

Christine,

I am assuming that there are no duplicate *Test ID*'s in column A.

See the attached workbook "Transpose rows to new sheets with titles -
Christine - SDG10.xls" with macro "TransposeData".

Then run the "TransposeData" macro.

Have a great day,
Stan


+-------------------------------------------------------------------+
|Filename: Transpose rows to new sheets with titles - Christine - SDG10.xls|
|Download: http://www.thecodecage.com/forumz/attachment.php?attachmentid=188|
+-------------------------------------------------------------------+

--
stanleydgromjr
------------------------------------------------------------------------
stanleydgromjr's Profile: http://www.thecodecage.com/forumz/member.php?userid=503
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=118597

Reply With QuoteReply With Quote