+ Reply to Thread
Results 1 to 9 of 9

Edit a value from to different cells

  1. #1
    Registered User
    Join Date
    03-16-2015
    Location
    Denmark
    MS-Off Ver
    Office 360
    Posts
    8

    Edit a value from to different cells

    Hey

    Is it possible to edit a value in a cell in sheet 1, so that it also changes in sheet 2, and then if i change the value in sheet 2 then it changes back in sheet 1 again?

    I have tried this macro, but it doesn't do the magic.

    Please Login or Register  to view this content.
    Does anyone have a solution to this?

  2. #2
    Registered User
    Join Date
    03-16-2015
    Location
    Denmark
    MS-Off Ver
    Office 360
    Posts
    8

    Re: Edit a value from to different cells

    Is it possible to use this function "ObjectListView.CELLEDIT", so that every time i change the sub cell, it also changes the primary cell?

  3. #3
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 365
    Posts
    8,081

    Re: Edit a value from to different cells

    Put this macro in the code module for Sheet1:
    Please Login or Register  to view this content.
    and this macro in the code module for Sheet2:
    Please Login or Register  to view this content.
    Keep in mind that as written, these macros will apply to all cells in the worksheets. If you want to limit this from happening to only certain cells, then I would need to know which cells you want to copy from one sheet to the next.
    You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
    Practice makes perfect. I'm very far from perfect so I'm still practising.

  4. #4
    Registered User
    Join Date
    03-16-2015
    Location
    Denmark
    MS-Off Ver
    Office 360
    Posts
    8

    Re: Edit a value from to different cells

    Thanks! it works.

    The certain cells would be E8 to E20. Does it have to be the same cells in sheet2?
    I have Interactive sheetnames, is it possible to link to the sheet in a nother way?

  5. #5
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 365
    Posts
    8,081

    Re: Edit a value from to different cells

    It doesn't have to be the same cells in Sheet2 but if those cells are different, then I would need to know the location of the cells in Sheet2. What do you mean by "Interactive sheetnames"?

  6. #6
    Registered User
    Join Date
    03-16-2015
    Location
    Denmark
    MS-Off Ver
    Office 360
    Posts
    8

    Re: Edit a value from to different cells

    D4 to D16 in sheet2.

    When i choose a nother year in E5 all but the startsheet change name. You can see it in the link below:
    http://www.filedropper.com/projektsuper1

  7. #7
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 365
    Posts
    8,081

    Re: Edit a value from to different cells

    We can refer to the sheets by using their codenames. At present, Sheet1 is named "Start" and Sheet2 is named "2005". Are these the two sheets in which you want the cell changes?

  8. #8
    Registered User
    Join Date
    03-16-2015
    Location
    Denmark
    MS-Off Ver
    Office 360
    Posts
    8

    Re: Edit a value from to different cells

    ok.
    Yes, lets just use them.

  9. #9
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 365
    Posts
    8,081

    Re: Edit a value from to different cells

    Have a look at the attached file. I was getting an "Out of stack space" error when I tried to combine the running of the NamesWS macro with the code to copy the cells from Sheet(1) to Sheet(2). By the way, Sheet(1) will always be the first tab and Sheet(2) will always be the second tab regardless of what the actual sheet names are. I separated the two procedures to avoid the "Out of stack space" error. In the "Start" sheet select the year in cell E5 and then click the "Run NamesWS" button. Your sheets will be updated. Now enter a value in any cell in range E8:E20 in the "Start" sheet or enter a value in the range D4:D16 in the second sheet and the values will be copied. I'm not sure if this will work for you but I don't know of any other way to avoid the error.
    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)

Similar Threads

  1. [SOLVED] Edit copied cells rather than original cells
    By garagemusic in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-22-2014, 11:20 AM
  2. Replies: 1
    Last Post: 08-29-2012, 04:01 AM
  3. Replies: 2
    Last Post: 06-29-2011, 11:28 PM
  4. Linking cells and still be able to edit both of them
    By casperft in forum Excel General
    Replies: 6
    Last Post: 02-08-2007, 10:55 AM
  5. Creating Hotspot Over Cells But Still Be Able To Edit Cells
    By crashoverride in forum Excel General
    Replies: 0
    Last Post: 01-04-2005, 07:54 PM

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