Merge Cells

[bboysen]

Ok so i know just enough VBA to mess things up!

This is what i have got.

I have a code in R2C7 and its code is XFL (crossing FenceLine). Then i have all the info for that crossing fenceline in other cells in the same row just in different columns. They are in the same place each time. What i want to do is have a vba code that will take the info from the other cells and merge in to one cell in the same row.

This is what the data looks like all in different cells:
Code Strands Height Type Condition
XFL 4 4 BARBED GOOD

This is how I want it to look like:
Comments
4' / 4 STRANDS / BARBED / GOOD


So what i was thinking the code would need would be an if statement and maybe and offset to each of the cells that would hold the data.

I have about 200 Codes that I would want this to do it to. I was thinking I would have to have an if statement for each code.

Like I said before I know enough VBA to mess things up. If I could get help to create the first one i think i might be able to take it from there.

Thanks

 

[mole999]

if your not doing it often, have you considered concatenate, then copy and paste special to just leave the values ?

 

[texasalynn]

is this what you need?

Excel Workbook
	A	B	C	D	E	F
1	Code	Strands	Height	Type	Condition	Comments
2	XFL	4	4	BARBED	GOOD	4' / 4 Strands / BARBED / GOOD
Sheet1

Excel 2003

Cell Formulas
Range	Formula
F2	=+B2&"' / "&C2&" "&$B$1&" / "&D2&" / "&E2

 

[bboysen]

See I do this everyday on about 5-8 different data sets. I would not mind doing the concatenate part is just a pain to type the formula each and every time. Is there a way to put that in to vba with the copy and past special? Each time i try to do that i get stupid errors.