move cells data

BillyKit

New Member
Joined
Dec 14, 2009
Messages
11
Hi everyone,

I have tables like shown below. The table consists of summary data in one row followed by the details below the row. Can anybody help to write a macro to move the details data to the cells as shown and delete the blank rows.
Thank you
 

BillyKit

New Member
Joined
Dec 14, 2009
Messages
11
can't see the table
I am sorry for the missing image.I'll repost my question.The table consists of rows of summary data determined by column A as in A2 and followed by one or more rows of details data below it. I need help to write a macro to move the details data to the summary row as in

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

 

BillyKit

New Member
Joined
Dec 14, 2009
Messages
11
Re: macro to move cells data

I posted this question earlier but somehow the image of sample data I link to did not appear.I have repost the question and hope someone will be able to help me.The table shown below contains rows of summary data determined by column A as in A2 and A4and followed by one or more rows of details data below it. The sheet may up to a thousand rows. I need help to write a macro to move the details data to the summary row 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

 

BillyKit

New Member
Joined
Dec 14, 2009
Messages
11
your first line of data shows a pattern but the second line doesn't, so I'm unable to help. And your table has never been shown only a "x" box. Try using the Jeanie to show your data
http://www.excel-jeanie-html.de/index.php?f=1
Hi, thank you for replying.


Excel Workbook
ABCDEFGHIJ
1DateQtyItemAmountSkuPlaceQty1ModeAmount1
217-Dec-0911.99Loc1Cash
3123456xxxxxxxxxx00111.99
419-Dec-09220Loc2Visa
5111112xxxxxxxxxx002110
6111113xxxxxxxxxx003110
720-Dec-09
Sheet1
 

Forum statistics

Threads
1,085,056
Messages
5,381,461
Members
401,740
Latest member
jphermans

Some videos you may like

This Week's Hot Topics

Top