If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Autofilter Lists across Multiple Sheets, Maintain Correct Referenc
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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Updating multiple distribution lists - why isn't this automatic w. | Tlogan | Contacts | 4 | August 22nd, 2008 04:44 PM |
Merging Multiple Contact Lists | Wayne | Installation & Setup | 1 | August 24th, 2005 02:01 PM |
multiple calendars, contacts, and task lists in outlook 2003 | mickey71 | General Discussion | 3 | April 29th, 2005 03:33 PM |
Multiple Contact Lists | I.Z. Anderson | Contacts | 2 | March 21st, 2005 05:29 PM |
(¯`·._.·[ Extract Data From Multiple Sheets ]·._.·´¯) | hyperdreamz | General Discussion | 1 | September 29th, 2004 04:03 PM |