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
excel_help.JPG
 

Some videos you may like

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.

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

excel_help1.JPG
 

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

excel_help1.JPG
 

BillyKit

New Member
Joined
Dec 14, 2009
Messages
11

ADVERTISEMENT

Hi, can somebody help?
 

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
 

Watch MrExcel Video

Forum statistics

Threads
1,122,233
Messages
5,594,963
Members
413,954
Latest member
mrsandy

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top