+ 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
    21

    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
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    Pro 2019
    Posts
    16,074

    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?
    Making the world a better place one fret at a time | | |會 |會 |會 |會 | |:| | |會 |會
    Please read the rules
    If someone helped you, click on the star icon at the bottom of their post
    If your problem is solved, go to Thread Tools and select Mark This Thread Solved
    Don't attach a screenshot--just attach your Excel file! It's easier and will let us experiment with your data, formulas, and code.

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

    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
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    Pro 2019
    Posts
    16,074

    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
    21
    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
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    Pro 2019
    Posts
    16,074

    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
    21

    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
    21

    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)

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