Duplicating Infromation from one worksheet to another?

I'm trying to automate some documents we use on a regular basis so that we don't have to re-enter the same information over and over again. Basically I can get some cells to work and some will not. My first sheet is a contract. So I want Customer and Contractor info to show up on the rest of the sheets. I'm assuming something is messed up in the formatting of the cells but I can't figure out what.

So on my Job Book Cover Sheet I first want the GC's name and the code =Contract!G8 works perfectly. In the cell just under this one I want the Customers Name, but =Contract!C8:D8 (the cells on the contract with the Customers Name) returns #VALUE!

That said, the code =Contract!C8:D8 on my project detailer sheet returns the customer name like I want it to.

Any Ideas?

The experts here usually ask that you upload a sample worksheet with what you have and examples of what you want to help them better solve your issues.

That being said, from what I can tell I assume you have first names in column c and last names in column d of you Contract sheet and you want it to appear as "Firstname Lastname" in a single cell elsewhere in your workbook. If thats the case a simple solution (in my mind) is to use the apersand symbol (&) to combine the contents of the cells. So for example in the case you listed above your formula would be:

=Contract!C8&" "&Contract!D8

Hope that helps.

No it's just one field, those 2 cells are merged.

If those cells are merged, just reference the first column of the merged set; in this case C8.

That fixed it, thank you very much!

No problem. Just trying to earn my keep around here and get some rep, that way I don't feel so bad about asking for lots of help too haha. Mark this as Solved?