Telling excel a cell equals another cell on a worksheet

**Dawn V** · 10-16-2009, 01:32 PM

Hello!

I'm trying to link data that is located on one spreadsheet and equal that to other information located in a different worksheet within the same file.

Please see HPRP A Vital stats in E,F,G 12
I want to have the inforamtion from the spreadsheet Staff - Client Pre Screening in cell D,E,F,G 12.

I tried the = function, but it is not working. Any ideas? Please see the attached.

**NBVC** · 10-16-2009, 01:36 PM

You are using merged cells which can cause heart-aches...

When you enter = and point to a merged cell, the entire merged range is referenced...giving you an error...

you need to remove the :G12 from the range

i.e. ='STAFF - CLIENT PRE-SCREENING'!D12

**Dawn V** · 10-16-2009, 01:40 PM

Thank you very much!

Solved.

**NBVC** · 10-16-2009, 01:41 PM

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save