Replies

JOHN YOU DA MAN!!!!!!!!!!! How the heck do you guys know all this stuff, your knowledge boggles me and saves me. Thanks

PS – the 2nd & was just a typo.

ED

It is being entered as just plain =A1 & “,” B1. The ( ) where used to show what was acually being displayed.

The sheet that these cells are going into is getting its data from a worksheet where project info is being entered. The cells that I am combining are last names of those responsible for a project. If I place their names in separate cells then Sheet 1 will be extremly long because up to 6 people can be responsible for one project. Also, Sheet 1 is linked to a Word Document Table and each project lies on 1 row with all responsible members on it. To make a project 4 lines long to cover 4 names is too bulky. I hope you get what I’m trying to say. Its a size and format issue mostly, but it was a good idea.

Ok that works fine but, I need the 2nd cell to be placed under the first one. When i use ALT + enter the formula stops calculating and displays what is exactly in the cell. (=A1 & “,” B1). How can i make it look like this: Smith
Jones

without losing my formula, thanks.

Ed

I figured it out using macro’s that take the colors form the ID sheet and combines it with the text from the Detailed sheet, it works ine. no need for VB here, thank a million though.

I have tried what u said but i get a run time error, heres how the code looks:

Sub DetailColor()
Dim dcell As Range
Range(“Detail”).Select ‘Cells that change ID# to text are labeled as a range “Detail”
For Each dcell In Selection
If dcell.Value “” Then ‘ If cell is blank then it gets skipped
Select Case dcell.Value
Case 1 ‘***HERE THE ERROR OCCURS***
dcell.Interior.ColorIndex = 3
Case 2
dcell.Interior.ColorIndex = 4
Case 3
dcell.Interior.ColorIndex = 6
Case 4
dcell.Interior.ColorIndex = 7
Case Else
End Select
End If
Next dcell
End Sub

i see what your saying but how can i make it relevant for my file. the attached file is a sample of my data and it explains what i am looking for on the FYI tab. i am a VB newbie so any help you have is great, pleas rememebr i don’t understand VB too well so i need some explaining here and there, thank you very much

Here is my file, the FYI sheet has all the info you’ll need. Thanks

WOW you guys and gals are amazing. Love the prompt replies and all the help. Worked like a charm. Thanks again!!!

Thanks but i used VLOOKUP and it got me where i need to be.