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: 2
Default Formula to copy another cell's contents - Help!

Is there a formula that will show what the contents of another cell is.

Example

A1 =(B1)
The Value of B1 is 'Test'
Therefore the value of A1 is 'Test'

However if I were to drag Cell B1 to, lets say, C1
The formula in A1 would automatically change to =(C1) and the value would
remain 'Test'.

I want it so the formula in A1 stays as =(B1), no matter if I move the cell

Is this possible?

Many Thanks
 
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
link to a cell's contents bluezcruizer Excel Worksheet Functions 1 December 3rd 06 12:49 PM
link to a cell's contents John Bundy Excel Worksheet Functions 1 November 30th 06 09:43 PM
link to a cell's contents bluezcruizer Excel Worksheet Functions 0 November 30th 06 03:55 PM
How do you copy a cell's content verses it's formula? Tammy Excel Discussion (Misc queries) 1 March 2nd 05 06:30 PM
Rotate a box with a cell's contents Circe Excel Discussion (Misc queries) 6 February 3rd 05 11:45 PM


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