+ Reply to Thread
Results 1 to 7 of 7

Linking cells and still be able to edit both of them

  1. #1
    Registered User
    Join Date
    02-08-2007
    Posts
    4

    Linking cells and still be able to edit both of them

    Hi

    Hope one of you can help me. I were wondering if it was possible to link to cells, and still be able to edit both the cells.

    Example:
    I have two worksheets, one is the calculation-sheet and the other one is a Input-sheet. I wanna make the input sheet for people who don't know everything about the "simulation". Thus, people should be able to type in information in the Input-sheet and it will change in the calculation-sheet. But I ALSO wanne be able to type in the calculation-sheet, and then it should change in the input-sheet. (Conclusion: write both places with a link between)

    Hope you understand, it is a bit difficult to explain ,
    Casper

  2. #2
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    4,070
    Hi,

    Not with a formula ... since a cell cannot have both a formula and a value ...
    It requires two simple worksheet events which play "ping-pong" ...
    HTH
    Carim


    Top Excel Links

  3. #3
    Registered User
    Join Date
    02-08-2007
    Posts
    4
    If i use macro's or something like that, would it then be possible?.... something with comparing the time of entering, and then save the newest in both cells?

    I would really help if it was possible somehow!

  4. #4
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    4,070
    No problem ...
    Are we only talking about two cells ...?

  5. #5
    Registered User
    Join Date
    02-08-2007
    Posts
    4
    No it is around 50-80 cells (and they are not in a straight row or collum). I'm still new to this, so actually, if you have a good idea for a code or where to read about it, I would be thankful

    I was thinking about this code, but so far i cannot limit it to a single cell:

    Private Sub Worksheet_Change(ByVal Target As Range)
    XXXXXXXXXXXXXXXX
    End Sub

    /Casper

  6. #6
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    4,070
    The first step is to establish the complete list of cells in sheet1 and their correspond cells in sheet2 ...

  7. #7
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    4,070
    Attached is a simple example you can adapt to your situation ...
    Attached Files Attached Files

+ 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