Forum Discussion
Excel question
Currently using excel 2013 - my question (or what I want to do) is this: I want to have a sheet (format that is printed out) but the information on that sheet is taken from a different tab - base...
you cna use INDIRECT to create a changing reference for example if your sheets are all starting with the same name and a changing number following it and put that number in another cell, lets say A1, you can create a formula like below to referecen B1 cell of different worksheets by changing the value in A1 cell:
=INDIRECT("DataSheet" &A1 &"!$B$1")
if the worksheet do not exists the formula will return #REF! error