Forum Discussion
How to link to every sheet whenever we create a new sheet into a common place
Hi Every Ony Happy New Year How do I give a formula to the same cell whenever I create a new sheet? For Eg:When I will create sheet4, and I want to have the same data in c6 by linking c5 in ...
Hello Sameer_Kuppanath_Sultan
- In the Summary sheet, type in =SUM(
- Click on Sheet2 and select C5
- Then, hold the SHIFT key on the keyboard and click on Sheet3
- Click Enter
This is called Group Sheet technique
Do let me know whether this answers your question