Forum Discussion
Question on a type of text linking between sheets
now it looks like your data is in cell E7 but I also realize my trick won't work because of circular reference (I use it for pulling prior total to new page starting value but here you are looking at the same cell).
So that said, you'll need to use =1!E7 on page 2 and =2!E7 on page 3 and so on
Thank you for your solution and formula m_tarler. :)
Am I doing this right? I've got it copied across sheets 1 to 31 with some data on sheet 1 and it's providing me with "0" no matter the data on the previous sheet. I'm definitely missing something here. I've also refreshed it. What's going on?
now it looks like your data is in cell E7 but I also realize my trick won't work because of circular reference (I use it for pulling prior total to new page starting value but here you are looking at the same cell).
So that said, you'll need to use =1!E7 on page 2 and =2!E7 on page 3 and so on