atuljadhavnetafim
Active Member
- Joined
- Apr 7, 2012
- Messages
- 341
- Office Version
- 365
- Platform
- Windows
Dear expert,
i have three sheets "Case1", "Case2" and "Case3" which has same formate and data as below, where Jan to Jun numbers are same in all three sheets but Jul to Dec numbers are differente in all the sheets., all three sheets Jan to June are Actual numbers and Jul to Dec are forecast numbers but in all three sheets Forecast numbers are different.
Now i have "Summary" sheet which also has same format and has Jan to June Actual numbers but Jul to Dec numbers comming from "Case1" sheets,
now what i want, i want to change the link in Summary sheet from "Case1" to "Case2" Or from "Case3"., and this changes will be frequent.
So, is there any way by clicking or by filtering somthing the cell reference will change automatically, i can do it manually by find and replace but since i have 40+ sheets and everytime it is not possible to change manually.
Thanks in advance.
i have three sheets "Case1", "Case2" and "Case3" which has same formate and data as below, where Jan to Jun numbers are same in all three sheets but Jul to Dec numbers are differente in all the sheets., all three sheets Jan to June are Actual numbers and Jul to Dec are forecast numbers but in all three sheets Forecast numbers are different.
Now i have "Summary" sheet which also has same format and has Jan to June Actual numbers but Jul to Dec numbers comming from "Case1" sheets,
now what i want, i want to change the link in Summary sheet from "Case1" to "Case2" Or from "Case3"., and this changes will be frequent.
So, is there any way by clicking or by filtering somthing the cell reference will change automatically, i can do it manually by find and replace but since i have 40+ sheets and everytime it is not possible to change manually.
Thanks in advance.