Macro to concatenate with previous bold cell

A

alovell

Can anyone help me with this? I am using pivot tables and I would like a Macro that would concatenate with the most recent, above cell, to create a unique value.

example

[BOLD]Pigs[/BOLD]
201201
201202
201203
[BOLD]Cows[/BOLD]
201201
201202
201203
[BOLD]Sheep[/BOLD]
201201
201202
201203

Which would result in

Pigs201201
Pigs201202
Pigs201203
Cows201201
Cows201202
Cows201203
....



This problem comes up for us a lot here, so a solution would be greatly appreciated. Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Concatenate cells with line breaks in them 4
Copying rows down into cells across until row=false ? 5
Concatenate a date and name 2
Can these look ups be done using Worksheets functions 6
Concatenate Puzzler! 3
Concatenate Text... with spaces 2
CONCATENATE not producing any results 3
Concatenate unique values among duplicates 5

Top