Macro Help

[NewbietoVBA]

I uploaded Dummy information in a worksheet on 4shared that is identical to what I am working with. The cumulative tab shows what I want pulled from the other worksheets.

http://www.4shared.com/file/MjTZvBFQ/DUMMY_DATA.html

The real job history tab in the full worksheet has 3500 rows, and the review history has 4300 rows.

The few examples have all 7 years of reviews and several positions. Not all rows will have a review yet (those that have started this year) and not all employee id's have more than one job history....... Please help! I'm hoping that any macro that will work on the DUMMY DATA worksheet will work for the whole worksheet.

Basically I want each employee id to have one row in the cumulative worksheet. All of their jobs will be put in the proper column (most recent job in current job column, 2nd most recent in the 2nd job column, and then the respective start dates in their columns and the same with the ratings).

Also, some ID's in the real worksheet have more than 10 jobs, but I want them cut off at 10.

I tried writing a macro but it was too large to execute. I am VERY new to VBA and am in a time crunch to get this done.

Thanks in advance for all the help!

 

[NewbietoVBA]

http://www.4shared.com/file/FEVOJ-7D/DUMMY_DATA_2.html

This is the new sheet with the employee ID #'s filled out in the cumulative tab.

I really need help on this, I got in way over my head.

Here's a link for my previous cry for help, with a little more explanation

http://www.mrexcel.com/forum/showthread.php?p=2840151&posted=1#post2840151

 

[VoG]

Please stick to your original thread.

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #9 here: http://www.mrexcel.com/forum/showthread.php?t=99490).