REFERRING TO DATA IN A DIFFERENT WORKSHEET

D

DAVE G

TODAY AT WORK WE WERE TRYING TO ENTER DATE INTO A CELL ON A WORKSHEET FROM ANOTHER WORKSHEET. THE SOURCE WORK SHEET WAS CALLED SUPPLIES AND THE CELL WAS D359. IN THE WORKSHEET WE WANTED THE DATA TO APPEAR WE USED THE COMMAND =SUPPLIES!D359. WHEN THIS INFORMATION WAS ENTERED THE SYSTEM CAME UP WITH AN ERROR MESSAGE SAYING THERE WAS SOMETHING WRONG WITH THE FORMULA. HOWEVER, WE CHECKED OTHER FORMULAS IN THE NEW WORK SHEET REFERRING TO DIFFERENT CELLS IN THE SUPPLIES WORKSHEETS AND THEY ALL USED THE SAME FORMULA AND THEY WORKED. DOES ANYONE KNOW HOW TO GET AROUND THIS PROBLEM?
 
K

Katherine Coombs

Hi Dave,

First a comment about etiquette - typing in capital letters is considered
"shouting".

The easiest way is to type = and then use your mouse to navigate to the
required cell on the required workbook and Excel will thereby create the
formula itself. That way you avoid any potential typos or similar finger
problems.

HTH,
Katherine

DAVE G said:
TODAY AT WORK WE WERE TRYING TO ENTER DATE INTO A CELL ON A WORKSHEET FROM
Click to expand...
ANOTHER WORKSHEET. THE SOURCE WORK SHEET WAS CALLED SUPPLIES AND THE CELL
WAS D359. IN THE WORKSHEET WE WANTED THE DATA TO APPEAR WE USED THE COMMAND
=SUPPLIES!D359. WHEN THIS INFORMATION WAS ENTERED THE SYSTEM CAME UP WITH AN
ERROR MESSAGE SAYING THERE WAS SOMETHING WRONG WITH THE FORMULA. HOWEVER, WE
CHECKED OTHER FORMULAS IN THE NEW WORK SHEET REFERRING TO DIFFERENT CELLS IN
THE SUPPLIES WORKSHEETS AND THEY ALL USED THE SAME FORMULA AND THEY WORKED.
DOES ANYONE KNOW HOW TO GET AROUND THIS PROBLEM?
 
D

Dave Peterson

Any chance you had a slightly different name "Supplies " (with a trailing
space)???

I like to let excel do the heavy listing.

I'll type = (equal sign) in the cell and then use the mouse to point at
supplies!d359. Excel will use the correct syntax and it's one less thing I have
to remember.

If that wasn't it, what was the error message?
 
Top