| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
moving answer from one sheet to another
I have two sheets
Sheet one column a is student's name, colums b thru k are a point system ranging from 1 to 3 points column l is the total of columns b thru k (no more than 30 points total). Sheet two has 5 columns. Each column is worth 6 points i.e. column a is 25 thru 30 points, column b is 19 thru 24 points, column c is 13 thru 18, column d is 7 thru 12 points and column e is 0 thru 6 points. I need the total on sheet one column l to move that student's name in that row to sheet 2 into the respective column of total points. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| moving informatiion from one sheet to a total sheet | Excel Discussion (Misc queries) | |||
| I'm trying to create a formula for an answer sheet. | Excel Worksheet Functions | |||
| add up cell content to get answer at bottom of sheet | Excel Discussion (Misc queries) | |||
| add up cell content to get answer at bottom of sheet | Excel Discussion (Misc queries) | |||
| I need to create a 7 bubble answer sheet for an experiment. | Excel Discussion (Misc queries) | |||
Threaded Mode
