Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy column from one sheet to another
I'm keeping grades in multiple worksheets in the same workbook. I'd like to
copy the column showing the total of the weekly grades (using the SUM formula) on worksheet 2 to the column on worksheet 1 for that assignment (worksheet 1 reflects all the assignments which is why I just need the sum). When I simply do a copy and paste, I get #REF in the 'weekly' column and in the 'total' and 'grade' columns (total is the total of all assignments, grade is a series of if, then statements so I end up with A, B, C etc). How do I do this to just get the number and not mess up worksheet 1? Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
To copy values in a column relevant to text in an adjacent column? | Excel Worksheet Functions | |||
Copy an additional row based on another sheet | Excel Discussion (Misc queries) | |||
Get other sheet names into a column | Excel Worksheet Functions | |||
reminder notifications in a column | Excel Discussion (Misc queries) | |||
Help with macro looping and color query function | Excel Discussion (Misc queries) |