Results 1 to 6 of 6

Returning the contents of a specific cell

Threaded View

afSE5 Returning the contents of a... 10-13-2014, 07:12 AM
boopathiraja Re: Returning the contents of... 10-13-2014, 07:16 AM
TMS Re: Returning the contents of... 10-13-2014, 07:19 AM
Punnam Re: Returning the contents of... 10-13-2014, 07:19 AM
afSE5 Re: Returning the contents of... 10-13-2014, 07:24 AM
TMS Re: Returning the contents of... 10-13-2014, 07:30 AM
  1. #1
    Registered User
    Join Date
    10-13-2014
    Location
    London
    MS-Off Ver
    5
    Posts
    2

    Returning the contents of a specific cell

    Hi,

    I am using 'Sheet 1' of a workbook and would like to return the value in cell 'C3' from 'Sheet 2'.

    Every time I add a line in 'Sheet 2' the formula in 'Sheet 1' auto corrects itself so that it now returns the value in cell 'C4' rather than 'C3'

    Does anyone know how how to stop this happening so that it always return the value in cell 'C3' regardless of what changes have happened on that workbook.

    Much appreciated.

    Af
    Last edited by afSE5; 10-13-2014 at 07:25 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Clear contents of specific cells on the same row if a specific cell on that row is empty
    By djfscouse in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-28-2014, 01:48 PM
  2. Returning one of 2 fomulas depending on contents of a cell
    By hannah225 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-27-2014, 06:24 PM
  3. Returning the contents of a specific cell using a MATCH of 2 other cells
    By oneblondebrow in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 04-08-2013, 08:41 AM
  4. Returning Cell Value if someone deletes the contents of a cell
    By mmc308 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-31-2006, 01:45 PM
  5. Returning contents of a cell
    By Dan in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-26-2006, 06:55 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1