Inserting rows in sub sheets and automatically adding to master sheet

[mrajalakshminair]

Hello Everyone,

I am working on a MIS file for my organisation. we have created a format which needs to be filled in by 30 of our employees, Now i have created a google sheet with 1 master sheet and 30 sub sheets and linked it.

The problem i am facing is the format is same across the 31 sheets and I want if i insert a row in any of the sub-sheets, it should appear in the master sheet and it should not overlap with the data in any other sub sheet.

it would be really great if anybody could help me.

Thanks!!
Rajalakshmi

 

[arthurbr]

Hi
as this is a Excel forum, if you need help with google sheets, the best way is to ask the question in Google sheet forums.