concatenate rows with columns based on conditional formatting in VBA?

**bandit_kaine** · 07-12-2010, 10:02 AM

Hi, i need a macro that concatenates a spreadsheet i have set up like this.

\1

Uploaded with ImageShack.us

Every row can have different amount of "colors" and each column can also have different amount of "sizes"

I need the macro to concatenate

A1 + C1 + A2 +B2 + C2 so that final result would be C14202_XSML_001-BLACK_3
i would need this done for each of the sizes, with each of the colors and each of the quantity values. The values in bold have to be matched with each of the values not in bold.

final result should be:

C14202_XSML_001-BLACK_3
C14202_SML_001-BLACK_10
C14202_MED_001-BLACK_7
C14202_LGE_001-BLACK_12
C14202_XLGE_001-BLACK_8
C14202_XSML_002-WHITE_0
C14202_SML_002-WHITE_-1

and so on.

Once the formatting changes to "BOLD" i would need the macro to start again with the new item code and repeat the process.

If someone can please help me with this i'd greatly appreciate it, this is my first excel macro i have used so if you could give me the complete module code it would really help.

**royUK** · 07-12-2010, 10:10 AM

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

**bandit_kaine** · 07-12-2010, 10:32 AM

Not sure if i understood correctly, i changed the title, i think it fits the rule now?

**bandit_kaine** · 07-13-2010, 09:33 AM

No one can help me? Do i need to explain better? This is really important for my work

**foxguy** · 07-15-2010, 03:16 AM

Letting you know that I have asked Roy if your title change is adequate. I can get in trouble if I reply. You can send him a Private Message yourself asking him how to modify your title better. Just click on his name in the upper left corner of his message and select "Send a Private Message to ...."