View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
BillyKit BillyKit is offline
external usenet poster
 
Posts: 1
Default Macro to move cells


I have a worksheet that contains rows of summary data determined by
dates in column A as in A2, A4,... and followed by one or more rows of
details data below it. Please, can someone help write a macro to move
the details data to empty cells in the summary rows as like


C3 to D2, E3 to F2, G3 to H2, I3 to J2
C5 and c6 to D4 AND D6 respectively and so on...

Thank you

I have attach a file to make this clearer.


+-------------------------------------------------------------------+
|Filename: excel_help1.JPG |
|Download: http://www.thecodecage.com/forumz/attachment.php?attachmentid=389|
+-------------------------------------------------------------------+

--
BillyKit
------------------------------------------------------------------------
BillyKit's Profile: 1313
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=163596

Microsoft Office Help