Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 19th 07, 09:29 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2007
Posts: 1
Default [=Sheet1!A1] - if i use Column A1 ('Sheet1') / A2 ('Sheet2')

Hi all.

SCENARIO: in Book1. Sheet1
column A1 with value="Sheet2"
column A2 with value="Sheet3"

If my Cursor is at Column B1. I can use [=Sheet2!A1] to retrive the
information store at Sheet2. A1 column

here with my crazy idea come from now. hope it is achievable.

If i would like to use this method [='A1'!A1 ]. It should derive the
information from the Sheet2. Due to my A1 column is "Sheet2 "

Instead it is prompting the Update value 'A1'

Anyone use this before?

--
Lawrence C H Tan
Singapore

Reply
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
Need Macro Help excelmad Excel Discussion (Misc queries) 7 January 19th 07 11:04 PM
Conditional Format as a MACRO Gunjani Excel Worksheet Functions 3 March 29th 06 05:22 PM
Positioning Numeric Values Resulting from 6 Column Array Formula Sam via OfficeKB.com Excel Worksheet Functions 2 January 5th 06 03:03 AM
Combine 3 Columns on Sheet2 to Display in 1 Column on Sheet1 Summer Excel Worksheet Functions 12 June 14th 05 02:56 PM
Help with macro looping and color query function kevinm Excel Discussion (Misc queries) 10 May 26th 05 01:25 AM


All times are GMT +1. The time now is 06:52 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017