Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with Excel sheets
Hello. I need help with developing a formula for data extraction:
Spreadsheet #1 contains student data which my IT dept. imports into a student intake database. Prior to import, however, I would like to extract test score information from a second spreadsheet. The common identifiers between the two spreadsheets are "Last Name" and "First Name" to identify the students. The columns I want to extract and place at the end of each student's data from sheet #2 to sheet #1 are "Total", "Written" and "Reading". I know this can be done but I am unsure because the record totals vary per sheet and I am just nervous because of the sensitive nature of the material (test scores!) Any help would be appreciated. Thank you. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Needle in a haystack...searching for VBA code in all Excel sheets orfinding xls users of xla sheets.... | Excel Programming | |||
How do I print sheets in Excel without blank sheets after page | New Users to Excel | |||
Print sheets by "All Sheets in workbook, EXCEPT for specific named sheets". Possible? | Excel Programming | |||
Macro for filter on protected workbook that works for all sheets, no matter what sheets are named? | Excel Programming | |||
Allocate Files to Sheets and Build a Master Sheet which Summarises All Sheets | Excel Programming |