Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
General
GeneralPortable MacsHardwareNetworking
Applications
Mac ApplicationsEudoraFirefox / MozillaInternet ExplorerOutlook ExpressMS OfficeEntourageExcelPowerPointWordVirtual PCMedia PlayerOther MS Products
Programming
Mac ProgrammingCodeWarriorPerl
Country Specific
Australian Mac GroupUK Mac Group

Mac Forum / Applications / Excel / September 2007



Tip: Looking for answers? Try searching our database.

Referencing a cell on a different sheet....

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Brightbelt - 24 Sep 2007 20:00 GMT
Hi,
I used to use Excel in Windows and I need to reference a cell and its value
on another sheet (same workbook etc).

In windows, it was something like:
!=sheet2(A33)

But this does not work on the iMac. Could someone help me learn this formula
for the Mac?

Many Thanks, Frank B.
Brightbelt - 24 Sep 2007 20:04 GMT
Ok, I got it....my apologies. I had it wrong. It is:
=sheet3!A33

No wonder it was not working - I had the exclamation mark placed wrong.
Thanks, Frank B.

> Hi,
> I used to use Excel in Windows and I need to reference a cell and its value
[quoted text clipped - 7 lines]
>
> Many Thanks, Frank B.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.