For those who use spreadsheets you could add a worth to 1 sheet of the spreadsheet after which marvel the right way to copy a worth to the opposite sheets. I’ve added a free function to my Add-on Bingo by Alice Keeler. Whereas the intention of this function is to repeat instructions from one Bingo sheet to the opposite Bingo sheets, it would work with ANY spreadsheet.
Hacking Alice’s Bingo Add-on
ANY SPREADSHEET! This does not have for use with Bingo.
Enjoying Bingo is FUN! You can begin a brand new spreadsheet and use the Add-on menu to pick “Bingo by Alice Keeler.” This may will let you create an inventory of phrases or phrases and switch them into distinctive Bingo Sheets per scholar. AFTER creating the Bingo sheets, choose any sheet and sort in some textual content. Use the Extensions menu to pick “Bingo by Alice Keeler” and selecting “Push Cell.” This may ship the chosen cell to the entire different sheets.
In case you are NOT utilizing Bingo, that’s okay! You possibly can choose ANY cell in your spreadsheet by single clicking on the cell. Use the Extensions menu and select “Bingo by Alice Keeler” and select “Push Cell.” This may ship no matter worth is in that cell to the entire sheets.
Please observe that this solely copies the VALUE of the cell. It does NOT push the method. It does NOT push the formatting.
Quick and Straightforward
Single click on on any cell on any sheet. Use the menu to pick “Push cell” and practically immediately that worth will present up on the entire different sheets.
NOT the First Sheet
Since that is designed for use with the Bingo Add-on it’s assumed that the FIRST sheet is your phrases checklist. In case you are on, for instance, the third sheet and push a worth from that sheet it would copy to ALL of the opposite sheets EXCEPT the primary sheet. If you need the primary sheet to have the worth copied additionally merely quickly add a brand new sheet within the first place.
TemplateTab by Alice Keeler
One in every of my favourite issues is to have ONE doc with all college students in the identical doc. What my free Add-on TemplateTab does is duplicates a graphic organizer per scholar. Nevertheless, what if you wish to make an replace to every of the sheets created you need to use the Bingo Add-on to push the VALUE of a specific cell to the opposite sheets.
SheetPusher by Alice Keeler
I even have an Add-on that’s designed to create a separate spreadsheet per scholar. That is completely different from TemplateTab that creates a sheet per scholar in the identical spreadsheet. After making a spreadsheet and copying the graphic organizer per scholar, it’s already constructed into SheetPusher to will let you spotlight a variety of cells and push these cells to every college students particular person sheets.