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.
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.
Last edited by 6StringJazzer; 05-23-2020 at 01:45 PM. Reason: clarified title
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?
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
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.
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
Here is the link
https://docs.google.com/spreadsheets...OmI/edit#gid=0
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.
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks