how do i move columns on one sheet to columns on another sheet

V

vaughn01

I have sheet one which is column "A" student's name columns "B thru K" are a
point system in each column (by 3 points either a score of 1, 2 or 3).
Column "L" is the total points summed across "B" thru "K". (a total of no
more than 30).

Sheet 2 is 5 columns with each column being worth 6 points. Column "A" is
25 thru 30 points, column "B" is 19 thru 24 points, column "C" is 13 thru 18
points, column "D" is 7 thru 12 points and column "E" is 0 thru 6 ponts.

I need column "L" on sheet one to move the students name on that row to
sheet 2 into the appropriate column based on his/her respective score.
 
R

Rob van Gelder

The formulas you want for columns A to E in Sheet2 are:
=IF(AND(Sheet1!$L1>=25, Sheet1!$L1<=30), Sheet1!$A1, "")
=IF(AND(Sheet1!$L1>=19, Sheet1!$L1<=24), Sheet1!$A1, "")
=IF(AND(Sheet1!$L1>=13, Sheet1!$L1<=18), Sheet1!$A1, "")
=IF(AND(Sheet1!$L1>=7, Sheet1!$L1<=12), Sheet1!$A1, "")
=IF(AND(Sheet1!$L1>=0, Sheet1!$L1<=6), Sheet1!$A1, "")

Cheers,
Rob
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

moving answer from one sheet to another 1
trying to get sheet 1 to recognize and move student names to pg 2 1
macro to copy columns from one sheet to another sheet 4
How to copy row data from Sheet2 to Sheet1 based on Conditional Date 2
Find value from one sheet and replace value in second sheet 3
Somewhat complex code to copy data from one sheet to another 9
I must make certain I have a specific range of numbers present. 3
Loop returns only one value, does not loop & an assignment to columnhow-to problem. 26

Top