Linking data between two worksheets...

[JohnnyT]

I have a workbook with several sheets in it. The idea is that you fill in a project sheet and it automatically fills in the corresponding invoice sheet. The two sheets are called : Project no. and Invoice1

Invoice1 was our current invoice sheet that I copied into this workbook.

I have cells in the invoice sheet that I want to be filled with data from the Project no. sheet.

I have used the formula...

='Project no.'!D16

And this works fine (its puts in the cell whatever the value is at D16 in the Project no. sheet)

However.. and here's the question, some of the cells aren't copying the data into them, they are simply displaying the formula ??

What could be causing that ?

As I said earlier, I didn't write the invoice sheet it was already there. Its strange that the formula works for half of the invoice sheet but not the other half, I'm wondering if there is a setting within the cells to tell them not to accept formulas ??

Can anyone help?

Thanks

John

 

[JohnnyT]

I've sorted this one out now. I spoke to the fella that made the invoice sheet up and he used one of excels own templates. I think there must be something in the formatting of this that's mucking it up. I've recreated the invoice in a new worksheet and its working fine now.

Thanks

JT