Can I move columns and rows from a Master Sheet that has cells linked in another sheet?

Alma Cardenas Mohn

I have a Master sheet with 25 columns and 185 rows. I linked cells from Master sheet to a secondary sheet (roll out sheet) to share with others who do not need to see everything on the Master sheet such as budget, etc. When I cell linked everything the columns were in the same order in the Master sheet as well as the secondary sheet/roll out sheet. However, now while I want the cells linked in same columns and rows that were originally linked, I want my Master sheet columns in a different order than the secondary sheet (roll out sheet). Am I able to keep my cells linked while not having the columns in the same order in both sheets?

Andrée Starå

Hi @Alma Cardenas Mohn

I hope you're well and safe!

Yes, if they are already linked, you can move them around.

I hope that helps!

Be safe, and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!