Sheet /Column sharing

penny53731

I have 5 sheets. The first 8 columns on each of the sheets are the same. The balance of the columns of each sheet are different. Is there a way to have the first 8 column interactive regardless of which sheet you are in. So whether you make a change in sheet 1 or 3 (within those 8 column) all 5 sheets in that cell are changed.

Gia Thinh

Hello @penny53731

To get the first 8 columns of 5 sheets interactive, formulas are required. We can choose 1 out of 5 sheets as the main sheet to edit the cells in the first 8 columns, the remaining 4 sheets will refer to the main sheet to pull data through the formulas.

We can use INDEX(MATCH()) functions to get data.

Hope that helps.

Andrée Starå

Hi @penny53731

I hope you're well and safe!

• Do you have anything in the sheet that we could use to match the rows between them?

I hope that helps!

Be safe and have a fantastic week!

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 or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!