LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 41
Default referencing a cell in another worksheet

Hi,
I want cell F55 in worksheet "January" to display what is typed in cell B6
of worksheet "Sheet 1". These two worksheets are in the same workbook. I've
typed "=Sheet1!B6" in cell F55, but instead of displaying "Jan. 4" which is
what is typed into cell B6 it is showing me the forumla that i typed. What am
i doing wrong/ how do i fix this?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Referencing a cell from another worksheet Shannan Excel Discussion (Misc queries) 3 November 20th 09 10:43 AM
Referencing a cell in another worksheet within the same workbook chickalina Excel Worksheet Functions 0 February 10th 09 01:50 PM
Referencing a cell to another worksheet neostar77 Excel Discussion (Misc queries) 1 October 13th 08 09:23 AM
Referencing a worksheet name to a cell... QuietMan Excel Worksheet Functions 10 May 20th 08 02:40 PM
Referencing another worksheet via a cell [email protected] Excel Worksheet Functions 2 October 31st 06 07:22 PM


All times are GMT +1. The time now is 06:36 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"