+ Reply to Thread
Results 1 to 2 of 2

matching cells from diferent worksheets

Hybrid View

calicali matching cells from diferent... 07-19-2007, 05:43 AM
Exodio Easy way is just to set cell... 07-20-2007, 11:38 AM
  1. #1
    Registered User
    Join Date
    07-19-2007
    Posts
    1

    matching cells from diferent worksheets

    Hi,
    I have a workbook that has 2 sheets A and B. Now, there is a column called "Age" (cell E7)which is common to both the sheets. So, when a user enters his age in Sheet A(in cell F7), it should get automatically update in the sheet B also. Im not sure which function to be used in Sheet B so that it can pick up values from F7 in the sheet A.
    Could anyone help?
    Thanks.
    Cali

  2. #2
    Registered User
    Join Date
    07-20-2007
    Posts
    4
    Easy way is just to set cell F7 in Sheet B to "=A!F7"
    Where A = your Sheet A name. If there is a space in the name of your sheet you should type ='Sheet A'!F7

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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