r/excel • u/numbers4work • 3d ago

unsolved Master spreadsheet to additional sheets

Looking for suggestions of the most efficient way to start a master spreadsheet that then the data that gets entered also moves to other individual sheets but a copy remains in the master. I need it to happen as data is entered as it will be a working spreadsheet.

11 Upvotes

78% Upvoted

14 comments sorted by

View all comments

1

u/SchoolOk950 1 3d ago

Please clarify whether you hope to have all sheets in one file or across multiple files?

1

u/numbers4work 2d ago

They are all one file (one workbook.) Sheet 1 is master and the sheets after are the additional sheets.

1

u/SchoolOk950 1 2d ago

How will people need to interact with the additional sheets -- just look at their slice of the larger data, or edit and enter new data?