Help! Collating with VBA (I think?)

Nlreid

New Member
Joined
Jul 21, 2010
Messages
7
Hi,

I need to reformat some data I received before I can put it into my statistical software. This programming stuff is all pretty new to me, so any input broken down as simply as possible would be greatly appreciated.

I have data on every student that was enrolled at my school for each semester- which is great, but I want to form cohorts. Like group all the fall 05 freshmen together, all the fall 06 freshmen together, etc. so i have an cohort for each year.

So in each dataset, I can filter it so that I only have incoming freshmen, say fall 05 cohort, and get every fall 05 freshman's ID # and other variables of interest in their first year. The problem occurs when I try to track them. When I go into the fall 06 dataset it gives me EVERY student who was enrolled at the time. Again, I can pull out the fall 06 cohort, but also want to find all the fall 05 students who are still enrolled and add their 2nd year statistics as columns in a totally separate freshman 05 cohort. So from each dataset year (starting in fall 05) I want to find that year's cohort and create a new dataset with that (which is easy) but I also want the data matching every ID # from a previous cohorts detected and added into the correct datasheet.

That way I can see each student- when they make dean's list, when they withdraw, when they take a leave of absence, etc.

Recap: have datasets of every student enrolled at each year; want to pull out freshmen and create workbook with just that cohort (done) then find the information for each ID # in every dataset after that so that I can track each student after their 1st year.

Is this possible? I have asked my boss to put Access on my computer, so if this would be done easier with that, that's possible too. Even just pointing my in the right direction would be awesome.

Thanks so much.
 

Some videos you may like

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

Watch MrExcel Video

Forum statistics

Threads
1,123,318
Messages
5,600,925
Members
414,416
Latest member
Nobu

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top