Hi have made a excel sheet , it only a work sheet in the first work sheet I will get main calculation of the 7 days . Each sheet is same as one only data entered will be changing
I have made like this
A1='sheet1'! K2 , and then A2='Sheet1'k7 ......like that
When I tried to drag the formula down the work sheet numbers are not changing only colum numbers are changing like k2, k3. .... like that the sheet number remain same. Is their any way to drag sheet numbers with out changing colum and row numbers I need to change work sheet names , ( the reference book) while dragging or is their any way to do it . Thanks in advance
Thanks
Sajan.rs
Sent from my SM-T311 using Tapatalk
Bookmarks