Search results for query: *

what i meant by "your almost right" is that you wrote: this C D multi-purpose van LT should become...

I meant: I dont know why they put the empty row there

Honestly I dont know why they do that...I am only working with the data I am given... I have a macro that deletes empty rows so I'll try that to make the groups contiguous and then use the code you gave me...I'll post any progress made so that others can use it

thanks!! it is now pasting in cells next to unbold ones... but concerning the groups that are not contiguous...you're almost right this C D multi-purpose vehicle van...

Yes they do... after going over the sheet again and again i think i know where the problem is...im not too sure but some of the data in the groups are not contiguous so they are like this C D Multi-purpose vehicle...

oh nevermind it works now...i recopied and pasted your code again...and changed Set r = rng.Cells(1, 1).CurrentRegion to Set r = rng.Cells(12, 1).CurrentRegion because the first cell to which it applies shows up on row 12 Just one little thing...it does not paste the bold data next to...

I tried the new code on a new excel sheet with the same data...however it does not do anything it doesn't say errors or anything...the sheet just stays the same when I click on macros the title is "MAIN" I select that and click run...but it doesn't work

Hi All So i need a macro that locates the bold data that come right after each other from a column ("D") then combines them in the cell next to them in column "C" and it keeps doing it for the next set of bold data that come right after each other here is what it should do before...

thanks for the help skip! im closer to what im looking for but it's not exactly it...right now it is taking ALL the bold data and putting them together in the cells in column C... here is what it should do before: C D acura...

yes the cells are contiguous and there might be cells that are not bold...in this case it should not select those...i actually need it to recognize only the bold ones and as soon as the macro come across a non-bold cell, it should stop there and not concatenate the data...then keep detecting...

sorry theres a mistake in my previous comment...heres the correct example before: C D rdx acura after: C D rdx acura rdx rdx acura acura

I'm sorry if i wasn't clear enough on my question i'm new to VBA and to these forums so here is what im looking for before: C D rdx acura rdx rdx acura acura after: corolla toyota 2011 corolla corolla toyota 2011...

Hi So i need a macro that locates the bold data come right after each other from a column ("D") then combines them in the cell next to them in column "C" and it keeps doing it for the next set of bold data that come right after each other thanks