+ Reply to Thread
Results 1 to 2 of 2

How to Mirror multiple individual cells in a single excel worksheet?

  1. #1
    Registered User
    Join Date
    01-09-2020
    Location
    Wyoming, USA
    MS-Off Ver
    Microsoft Office Home & Business 2016
    Posts
    1

    Wink How to Mirror multiple individual cells in a single excel worksheet?

    I am trying to "mirror" multiple cells in a single excel worksheet. When I edit one cell, I need the others to update as well. But I want the liberty to edit any one of the cells, not just one. In other words, I need it to be multi-directional.

    I did search the forum but only found references to linking either entire columns or linking cells between worksheets. I am looking to link multiple individual cells in a single worksheet.

    For instance, I want the following cells linked: D71, H71, L71, D133, H133, L133, D197, H197, L197, etc.
    But I also need these cells linked too: D72, H72, L72, D134, H134, L134, D198, H198, L198, etc.

    I need to set up these "links" for approximately 30 different strings in the workbook.

    My experience with VBA/Macros is limited. I appreciate any help you all can provide.

  2. #2
    Forum Expert WideBoyDixon's Avatar
    Join Date
    10-03-2016
    Location
    Sheffield, UK
    MS-Off Ver
    365
    Posts
    2,182

    Re: How to Mirror multiple individual cells in a single excel worksheet?

    You didn't provide a full spec of which cells need to be linked so this is probably only a partial answer. Right click the tab name and select "View Code" then paste this code:

    Please Login or Register  to view this content.
    WBD
    Office 365 on Windows 11, looking for rep!

+ 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. Replies: 8
    Last Post: 02-15-2016, 10:08 PM
  2. Macro to copy data from multiple worksheet cells in to a single Master worksheet
    By thunt13 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-08-2015, 03:24 PM
  3. Seperating Multiple Data in a Cell into Single Data Individual Cells
    By sgmgrider in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-22-2015, 11:47 AM
  4. [SOLVED] Copy multiple numbers from a single cell to individual cells
    By Styler001 in forum Excel General
    Replies: 5
    Last Post: 04-15-2014, 01:23 AM
  5. Importing Multiple individual txt files into one single spreadsheet using 2003 Excel
    By keige123 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-22-2013, 10:29 PM
  6. [SOLVED] Need a Macro to grap individual data cells and check box data,Multiple files into single
    By Ghostwheel in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-19-2012, 04:42 PM
  7. VBA Code To Mirror Cells from one Worksheet to another
    By Daniel1234 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-05-2010, 07:03 AM

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