E
EDSTAFF
Using Excel 2003, XP-MCE
File with multiple sheets.
Sheet 1 is Roster. Only sheet where input of name is allowed.
List created for sorting via any column. Column B is 1,2,3... Column C is
Last Name, Column D is first name, Columns D:K contains numbers, emails, etc.
Sheet 2 is SUMMARY of all professional certifications. Individuals first and
last names linked to Sheet 1, Columns C/D. Columns E:M linked to Sheets,
4:10, J Column (time period in Y/M/D until certification expires,
conditionally formatted). List created for sorting via any column.
Sheet 3, Same as Sheet 2 but with data other than certifications. Linked in
similar fashion as Sheet 2. List created for sorting via any column.
Sheets 4-10. INDIVIDUAL Certifications. Columns C/D linked to sheet 1 Roster
Columns C/D(individual names). Columns E-I, various input data (dates,terms,
expiration dates,etc.) used to calculate Column J (time before expiration of
certification, conditionally formatted). Lists created for sorting by any
column.
I want all sheets to have Lists for sorting by any column heading and have
data move correctly with Columns B/C/D from Sheets 4-10, Column J(Individual
Certifications) to Sheet 2 (Summary of Certifications). In other words, I
need to make sure calculated data in Sheets 4-10,Column J is correctly
carried over to Sheet 2 regardless of what sorting is used on individual
sheet. Unfortunately, that is not what is happening as data linked to Sheets
4-10, J Column does not stay with the correct name of the individual, Column
C/D, linked to Sheet 1. I hope this makes sense. I have tried Group/Outline
via row/column but that doesn't seem to fix the issue. INDIVIDUAL sheets sort
correctly, except for data linked to sheets other than Sheet 1, Roster.
Anyone have any ideas on how to get this to work correctly?
Thanks,
L.M.
File with multiple sheets.
Sheet 1 is Roster. Only sheet where input of name is allowed.
List created for sorting via any column. Column B is 1,2,3... Column C is
Last Name, Column D is first name, Columns D:K contains numbers, emails, etc.
Sheet 2 is SUMMARY of all professional certifications. Individuals first and
last names linked to Sheet 1, Columns C/D. Columns E:M linked to Sheets,
4:10, J Column (time period in Y/M/D until certification expires,
conditionally formatted). List created for sorting via any column.
Sheet 3, Same as Sheet 2 but with data other than certifications. Linked in
similar fashion as Sheet 2. List created for sorting via any column.
Sheets 4-10. INDIVIDUAL Certifications. Columns C/D linked to sheet 1 Roster
Columns C/D(individual names). Columns E-I, various input data (dates,terms,
expiration dates,etc.) used to calculate Column J (time before expiration of
certification, conditionally formatted). Lists created for sorting by any
column.
I want all sheets to have Lists for sorting by any column heading and have
data move correctly with Columns B/C/D from Sheets 4-10, Column J(Individual
Certifications) to Sheet 2 (Summary of Certifications). In other words, I
need to make sure calculated data in Sheets 4-10,Column J is correctly
carried over to Sheet 2 regardless of what sorting is used on individual
sheet. Unfortunately, that is not what is happening as data linked to Sheets
4-10, J Column does not stay with the correct name of the individual, Column
C/D, linked to Sheet 1. I hope this makes sense. I have tried Group/Outline
via row/column but that doesn't seem to fix the issue. INDIVIDUAL sheets sort
correctly, except for data linked to sheets other than Sheet 1, Roster.
Anyone have any ideas on how to get this to work correctly?
Thanks,
L.M.