Forum Discussion
How do I mirror cells from one master spreadsheet onto other tabs?
I am a teacher in a secondary school and I am hoping to be able to create a master spreadsheet which holds the data for my students (which will be organised alphabetically) that I can populate with d...
Hi, Jess. You may not be able, for privacy reasons, to share actual copies of your actual spreadsheet, but you could share a mockup--just change names and any other identifiable data, and make it more limited. Use names of StarWars or Disney characters...
That said, sight unseen, you might well benefit from the newly added FILTER function. It does require the most recent version of Excel. Here's an excellent video that introduces it. https://www.youtube.com/watch?v=9I9DtFOVPIg