Forum Discussion
How to copy a cell from all tabs to another cell in all tabs
- You can group tabs and any formula you enter in a cell will be entered in that same cell on all grouped tabs. Simply click the first tab and -if the tabs are in consecutive order- shift+click the last tab. Now enter that formula. When done, remember to ungroup the tabs: right-click any of the tabs and choose Ungroup.
=B10
Now press Enter and your cell should reflect whatever is in cell B10.
JKPieterseThank you Jan. If I understand correctly your method is not any different than simply cutting and pasting from one cell to another. Perhaps I did not explain myself well or did not understand your answer.
I want to do one command, similar to cut and paste from one cell to another but this one command would cut and paste the total of tab 1 cell X to the 2nd cell (Cell Z) in tab one, and then through this one command (which would not have to be repeated) I would see the same thing in all other tabs. In other words tab 2 would have cell X copied to its cell Z, tab 3 would have its cell X copied to its cell Z, and tab 4 would have its cell X copied to its cell Z, and so on so forth for all 30 tabs
- You can group tabs and any formula you enter in a cell will be entered in that same cell on all grouped tabs. Simply click the first tab and -if the tabs are in consecutive order- shift+click the last tab. Now enter that formula. When done, remember to ungroup the tabs: right-click any of the tabs and choose Ungroup.
Thank you so much. Extremely appreciated.