View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
vaughn01 vaughn01 is offline
external usenet poster
 
Posts: 3
Default how do i move columns on one sheet to columns on another sheet

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.