Semi Noob - Sheets+formulas Help

[StephB]

Hi

I'm fairly comfortable with excel but I got a head-scratcher here tha
no one in our office could figure out

Scenario

In column A, I have a list of students, In column B is whether they rea
a particular book, in C is another book and so on

I've created a masterlist sheet and a template sheet but now I want t
use my template sheet and copy paste it into multiple sheets but I nee
my formulas to change according to the sheet it's on

EG: template formula =IF(Masterlist!B1="yes","Yes","No")
needs to change to =IF(Masterlist!C1="yes","Yes","No") if it's on a 4t
sheet

What would I need to do to change the row, to change the column,
and change both? (I am just trying to figure what book are most popula
and what the student actually did this term

Lastly, is there a method of automating the creation of sheets by usin
the template

EDIT: I am using excel 200

 

[Spencer101]

Hi

I'm fairly comfortable with excel but I got a head-scratcher here tha
no one in our office could figure out

Scenario

In column A, I have a list of students, In column B is whether they rea
a particular book, in C is another book and so on

I've created a masterlist sheet and a template sheet but now I want t
use my template sheet and copy paste it into multiple sheets but I nee
my formulas to change according to the sheet it's on

EG: template formula =IF(Masterlist!B1="yes","Yes","No")
needs to change to =IF(Masterlist!C1="yes","Yes","No") if it's on a 4t
sheet

What would I need to do to change the row, to change the column,
and change both? (I am just trying to figure what book are most popula
and what the student actually did this term

Lastly, is there a method of automating the creation of sheets by usin
the template


EDIT: I am using excel 200

Hi, I'm struggling to fathom why you'd want to do this. If everythin
is in one big "table" already, why can you not just do your analysi
from there

Don't get me wrong, I'm happy to help, but some idea of what you'r
actually trying to do would be a great help