reformatting

rbs

Board Regular
Joined
Oct 6, 2002
Messages
58
I have a 270pg spread sheet with cells in the following format...

Colour Printer
Ink Ctg Black
Ink Ctg Colour

Colour Stylewriter 2200
Ink Ctg Colour
High Performance Blk Ink Ctg
Ink Tank Tricolour
Ink Tank Black

I need to create a macro to repeat the header line of each section with all the products repeated below it, so it appears as following...

1500 Ink Ctg Black
1500 Ink Ctg Colour

2200 Ink Ctg Colour
2200 High Performance Blk Ink Ctg
2200 Ink Tank Tricolour
2200 Ink Tank Black
 

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

Forum statistics

Threads
1,144,362
Messages
5,723,909
Members
422,527
Latest member
JayTheKaz

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