Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.misc
DA DA is offline
external usenet poster
 
Posts: 104
Default Cell Address










Thanks. It worked. It was so easy, I should have known that, duh...












"Sheeloo" wrote:

Enter in the desired cell in Sheet4
(I am assuming sheet name is Sheet1 for worksheet1)

=Sheet1!D4

OR you can also enter = in any cell in Sheet4
Then click on Sheet1
Click on D4
Press Enter and you are done

The number I want to copy from is on worksheet 1 and copy to worksheet 4.
The cell address in worksheet 1 is Row 4, Column D.

--
If you find this post helpful pl. choose "Yes"...


"da" wrote:

HI
I want to copy a cell address which is on a different worksheet (same file).
How do I do it? I tried using the ADDRESS formula but it does not show
correct result.


thank you

 
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
Find cell address of last cell in a column with text mike in texas Excel Worksheet Functions 8 October 4th 08 05:41 AM
find last cell in range with data, display cell address sevi61 Excel Worksheet Functions 14 October 29th 07 08:36 PM
Data Validation: Store cell address instead of value in the cell? WillW Excel Discussion (Misc queries) 1 January 31st 07 02:22 AM
How to create table of cell names with the name's cell address WildwoodEngr Excel Discussion (Misc queries) 1 October 26th 06 02:52 PM
How make hyperlink refer to cell content rather than cell address. Omunene Excel Discussion (Misc queries) 3 March 2nd 06 01:07 AM


All times are GMT +1. The time now is 12:25 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"