×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Linking data between two worksheets...

Linking data between two worksheets...

Linking data between two worksheets...

(OP)
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

RE: Linking data between two worksheets...

(OP)
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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources