Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old August 1st 12, 04:23 PM
Junior Member
 
First recorded activity by ExcelBanter: Aug 2012
Posts: 1
Default Semi Noob - Sheets+formulas Help

Hi,

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

Scenario:

In column A, I have a list of students, In column B is whether they read 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 to use my template sheet and copy paste it into multiple sheets but I need 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 4th 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 popular and what the student actually did this term)

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


EDIT: I am using excel 2007

Last edited by StephB : August 1st 12 at 04:28 PM

  #2   Report Post  
Old August 11th 12, 06:09 PM
Senior Member
 
First recorded activity by ExcelBanter: Mar 2012
Posts: 663
Default

Quote:
Originally Posted by StephB View Post
Hi,

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

Scenario:

In column A, I have a list of students, In column B is whether they read 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 to use my template sheet and copy paste it into multiple sheets but I need 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 4th 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 popular and what the student actually did this term)

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


EDIT: I am using excel 2007
Hi, I'm struggling to fathom why you'd want to do this. If everything is in one big "table" already, why can you not just do your analysis from there?

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

Last edited by Spencer101 : August 11th 12 at 06:12 PM


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Enabling formulas in a semi-protected sheet cbr Excel Worksheet Functions 0 November 22nd 10 01:36 PM
Formulas need semi-colon, how to change to comma dk Excel Discussion (Misc queries) 1 July 12th 06 03:27 PM
Not-so-noob Don[_22_] Excel Programming 3 October 4th 05 07:32 AM
nOOb formulas question patrick Excel Discussion (Misc queries) 1 March 8th 05 02:42 PM
Help Im a nOOb. cell formulas. patrick New Users to Excel 1 March 7th 05 10:32 PM


All times are GMT +1. The time now is 10:33 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017