excel macro/vb data reduction projec

We would like a visual basic program/excel macro that reorganizes one excel file by extracting specific variables and pasting them into a new excel file. Essentially, we want to manipulate many (450) rows of data per person into one row of data in a new excel file but the new row will include some variables calculated from the larger set of rows. (We will attach this description in a better formatted word document). So, we want to reorganize and do a few simple conditional analyses for a group of research subjects (all subjects are in this one accompanying file). Column A indicates the subject # (repeated for each line until we reach the next subject, i.e., 3022 is first subject, 3023 is the second subject). Each subject has about 450 rows and we have about 120 subjects.