Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
emerb
 
Posts: n/a
Default Paste link versus allowing two cells equal each other?

What is the difference between these methods?
  #2   Report Post  
JE McGimpsey
 
Posts: n/a
Default

Paste link simply enters a link formula, e.g, copy A1, select B1, and
choose Edit/Paste Special/Paste Link results in B1 containing =$A$1.

"Allowing two cells to equal each other" is rather too ambiguous for me
to be sure what you mean.


In article ,
"emerb" wrote:

What is the difference between these methods?

  #3   Report Post  
emerb
 
Posts: n/a
Default

Thanks a million for your reply,
I'm familiar with using the paste special method. What i meant by the two
cells equalling each other is where you enter the equals sign into we'll say
cell A1 and then select cell B1 and press return.

What is confusing me is why with paste special you get the =Sheet1!$B$1 but
by using the equal sign you get =Sheet1!B1. How do you know which method is
the most appropriate?

"JE McGimpsey" wrote:

Paste link simply enters a link formula, e.g, copy A1, select B1, and
choose Edit/Paste Special/Paste Link results in B1 containing =$A$1.

"Allowing two cells to equal each other" is rather too ambiguous for me
to be sure what you mean.


In article ,
"emerb" wrote:

What is the difference between these methods?


  #4   Report Post  
JE McGimpsey
 
Posts: n/a
Default

See the "The difference between relative and absolute references" topic
in XL Help.


In article ,
"emerb" wrote:

What is confusing me is why with paste special you get the =Sheet1!$B$1 but
by using the equal sign you get =Sheet1!B1. How do you know which method is
the most appropriate?

  #5   Report Post  
emerb
 
Posts: n/a
Default

Heya again,
Yeah i know the difference between absolute and relative. What is confusing
me is that the cell that isnt absolute ie: =Sheet1!B1 seems to behave as an
absolute reference. I have moved B1 to several other locations and checked
the result on the the link in cell A1 and it always refers to B1 in both
cases ie: paste special and =. I would have assumed that it wouldn't but it
does. That's either very strange or christmas is catching up on me!!

"JE McGimpsey" wrote:

See the "The difference between relative and absolute references" topic
in XL Help.


In article ,
"emerb" wrote:

What is confusing me is why with paste special you get the =Sheet1!$B$1 but
by using the equal sign you get =Sheet1!B1. How do you know which method is
the most appropriate?




  #6   Report Post  
JE McGimpsey
 
Posts: n/a
Default

Yes, if you move a reference, either by dragging or by cutting and
pasting, XL will always update the reference, just as if you inserted a
row/column.

If you want to always refer to B1, even if you cut and paste, or add
rows, etc., use

=INDIRECT("B1")



In article ,
"emerb" wrote:

Yeah i know the difference between absolute and relative. What is confusing
me is that the cell that isnt absolute ie: =Sheet1!B1 seems to behave as an
absolute reference. I have moved B1 to several other locations and checked
the result on the the link in cell A1 and it always refers to B1 in both
cases ie: paste special and =. I would have assumed that it wouldn't but it
does. That's either very strange or christmas is catching up on me!!

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
How do I link many cells to one particular cell? fish@divi Excel Discussion (Misc queries) 2 January 5th 05 12:00 AM
How do I link many cells to one particular cell? justinfishman22 Excel Discussion (Misc queries) 2 January 4th 05 01:09 AM
How do I unlink cells in M.S. 2003 Access? They link when my stud. Tea Excel Discussion (Misc queries) 1 January 3rd 05 07:25 PM
How do I select a range if one cells contents is equal to another KHarrison Excel Discussion (Misc queries) 2 December 20th 04 10:35 PM
Paste a chart as a link? PhilGTI Charts and Charting in Excel 3 December 4th 04 06:31 AM


All times are GMT +1. The time now is 05:24 PM.

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

About Us

"It's about Microsoft Excel"