Excel Help- Manual work and macro work need help

I need some help in updating the excel spreadsheet attached based on the other "data spreadsheet". The excel data spreadsheet drives the other excel spreadsheet that has all the offices, classes (only 3 right now, elw bat ilw), and the titles (BA, ASC etc.). What needs to be done is if you look at the data excel file you will see all this information is there for all classes, I need you to double check what I had created a year ago in the other excel and use the data sheet to update it. I ohpe that makes sense. Basically if the IN office doesnt send BA to a class called ILW, then change it in my excel sheet since the data now shows it that way, basically you have to update my information excel file based on the new data file. Also, we need to add all the classes to the information excel file instead of the 3 you see now at the bottom of the screen (ilw bat elw). offices will also have to deleted / added based on what offcies are there now in the data sheet and which ones dont exist anymore. I hope this is all making some sense. I dont want to confuse. Please feel free to ask me anything at all. steps are given in detail in the other section of description. ## Deliverables There are two files. 1. css titles and progression 2. 2008 all core attendees the 2008 core attendees is the data file that should determine what need sto be in the css titles file. css titles file has a smiple macro that takes page to page. what we need is to have it automatically be updated based on the data from the 2008 all core attendees data. you will see i have manually entered values for each office like "AP", "AS", "AU" etc. then if you click on one it shows you their landscape as in what courses each css title goes to (MMBA, BCR etc.). Now this data is driven by our other sheet as you will see in the pivot table. So in the end i want to eliminate me manually looking at my data sheet then going to css titles sheet and updating it. I hope that makes sense? Also we need something to track changes, perhaps a sheet that tracks any new changes. If a new office, title, or course has to be added it should be added on the css titles but in a different font so we know the change. I hope this is not too confusing . I am avail all day if you have any questions at all. No modify should be done on "2008 all core attendees" this is the data driver for hte other excel sheet that is the report. Best way would be to look through my data excel file and the information excel file and you will see what I had done a year back. Thank you! Here are the steps in detail: Steps- 1. First open the 2008 all core attendees and the Css titles and path… file. 2. the only tab used in the 2008 all core attendees file is the all tab, you can pivot anyway you like for easy comparing. The key data point we want to compare is the column J and L using column A, G, and M to match against the report page 2008 all core….file. 3. We want to use the 2008 all core attendees file which is the data file to populate the CSS titles and path… file. Our goal is to make updates to what we already have and to add new “org??:or “skill at training?? titles where necessary. To add just add direcstly in css titles… file. 4. All changes made to the CSS titles… file must be done in red font so we know what change are made. 5. Alright to navigate in the css titles and path progression….file, you can always clik on the red button on top right of any page to get to home page. 6. once on the home page (main menu…..) you can click on any link on the top (ap, as, etc.) to get to the sub page. What these ap as au bl are, is basically the offices, the SAME offices that you see on the 2008 all core…data file as ORG. So what we want to do is go through each office by clicking on the link to the sub page and then looking at the subpage we will see CSS titles going across the table, this is the same titles that we see as SKILL AT TRAINING in the data sheet 2008 all core….So now we have 2 dimensions matching up data sheet to report page. The third dimension to match is the course. In the data sheet its called PROGRAM_CODE. In report page its called CSS TITLE. 7. Once you follow this it’s a matching and checking work after this. You match the three dimensions in the report CSS Titles…page to data page and see if we have the right data in the report page, if not then we want to update it in red font. You might have to add new titles or offices, NOT courses. 8. You will see that in the css titles…report page we see ranges in the data like 0-3, 7-12 etc. insated of one number like we do in the data page 2008 all core… so how do we match? Simple, if in the data page its 17.2 for one guy and 20 for one, then the range would be 17-20. So check this in the report page and if its 17-20 then you are fine, if not then change it. 9. One important point to keep in mind is that you need to compare the right numbers. Sometimes its tenure in position sometimes its tenure since associate. It depends on the org and the program. 10. You will also see that I created 3 program links on the bottom of the report file. We need this created for all programs. It doesn’t have to exact same but does need to have the basic info about each offices that take the course and the tenures. The point here is to mention the offices ONLY if they are exceptions. For example is normal tenure since associate to go to program for all offices is 12-15 but office GC sends at 19-25, THEN ITS AN EXCEPTION and should go on this special page. 11. This really is it for the project interms of the core job. Apart from that, it is important to figure out a way to create macro so that the report page css titles… is automatically updated based on the data page. * * *This broadcast message was sent to all bidders on Tuesday Feb 17, 2009 8:54:48 AM: Please see if able to do some manual excel work and limited macro work.