+ Reply to Thread
Results 1 to 8 of 8

How to mirror multiple cells in multiple worksheets (need Google Sheets macro)

  1. #1
    Registered User
    Join Date
    05-05-2020
    Location
    Manila, Philippines
    MS-Off Ver
    Office 365
    Posts
    22

    How to mirror multiple cells in multiple worksheets (need Google Sheets macro)

    hi im working on something and i need your help on this. I need to mirror some cells from the master sheet to another sheet and in vice versa. User can input on both sheets and mirror the value from one sheet to another.
    Attached Files Attached Files
    Last edited by 6StringJazzer; 05-23-2020 at 01:45 PM. Reason: clarified title

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: How to mirror multiple cells in excel

    I can show you how to mirror them, but a better design would be to create a new sheet for data entry and then have that data flow to these two different formats. It is simpler, and more reliable. Is there a particular reason you need it like this?
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    05-05-2020
    Location
    Manila, Philippines
    MS-Off Ver
    Office 365
    Posts
    22

    Re: How to mirror multiple cells in excel

    HI sorry just saw this reply - here's the link

    Hope you can help me how to do 2 way mirroring in google sheet.

    All the gray cells from Player sheet must reflect on the Master sheet and from Master sheet can update/input data on the gray cells also.

    Thanks

  4. #4
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: How to mirror multiple cells in excel

    There is no link, and you may not be allowed to post a live link. PM me the link and I will add it.

    If this is Google Sheets then I need to move the thread. VBA does not work in Google Sheets, and I don't know the Google Sheets macro language.

  5. #5
    Registered User
    Join Date
    05-05-2020
    Location
    Manila, Philippines
    MS-Off Ver
    Office 365
    Posts
    22
    I actually done with excel. Vba - macros.

    But i need to make it a live sheet so i transfer it in google sheet. 😔

    Hope experts like you in this channel can help me with this.

    Thank you

  6. #6
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: How to mirror multiple cells in excel


  7. #7
    Registered User
    Join Date
    05-05-2020
    Location
    Manila, Philippines
    MS-Off Ver
    Office 365
    Posts
    22

    Re: How to mirror multiple cells in excel

    It seems the link is still the same as i made. I can only enter data from player 1 and cannot edit it from the master file.

  8. #8
    Registered User
    Join Date
    05-05-2020
    Location
    Manila, Philippines
    MS-Off Ver
    Office 365
    Posts
    22

    Re: How to mirror multiple cells in excel

    Hi im working on a portfolio and it has to be live. I actually manage to do it in excel via macros. But since we need to use the portfolio live so i have to shift over everything in Google sheet. However, i don't know how to read and code google app script and i don't know how to mirror cells that can be both updated and edited by the user in different sheets.

    I hope you can help me on this.

    Here's the link - https://docs.google.com/spreadsheets...it?usp=sharing

+ 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. 2-way mirror of multiple cells across multiple worksheets
    By buidiena3 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-19-2020, 01:14 AM
  2. 2-way mirror of multiple cells across multiple worksheets
    By samkeane83 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-20-2020, 03:16 AM
  3. How to Mirror multiple individual cells in a single excel worksheet?
    By ms_dawn in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-09-2020, 07:31 AM
  4. Mirror multiple cells across multiple worksheets.
    By leovfx in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-02-2017, 09:35 AM
  5. [SOLVED] How to mirror 3 cells across multiple sheets in a workbook?
    By NickyHavey in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-06-2016, 05:25 AM
  6. Mirror cells - two worksheets, random cells. Attempted code provided
    By ld2x07 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-18-2014, 09:30 AM
  7. Mirror multiple cells in different sheets
    By abarney in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-18-2012, 03:13 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