Thread: How to copy from sheet1 then paste special transpose to sheet2,3,4
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Christine Christine is offline
external usenet poster
  
Posts: 147
Default How to copy from sheet1 then paste special transpose to sheet2
Stanley,
I tried the macro and worked really well! Thanks! You're a time saver!
-Christine

"stanleydgromjr" wrote:


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