link to diff workbook IF dates match

Microsoft Office excel 2007 home & stude...
November 22, 2010 at 10:03:43
Specs: Windows XP
I have an excel spreadsheet with about 15 columns that is a list of students with their school name, start date and end date, SIN, Date, First Name, Last Name, Birth date, etc.

I have a different spreadsheet that has a separate tab for each month.

I would like a formula or macro or coding(and how to use it) that would take the date column from spreadsheet 1, and if the date is in the month of September, it will copy 4 of the columns from that row into spreadsheet 2 into tab "September". and the same if the date is in October it would copy into tab "October" in spreadsheet 2, and on and on.

Thank you for your help

See More: link to diff workbook IF dates match

Report •

November 22, 2010 at 11:20:20
Hedi, EDIT your post and remove your email address, unless you really like getting spam.

There are nasty little bots that scan public post looking for email address.


Report •

November 23, 2010 at 07:39:17
I'd like to add:

The Main spreadsheet is a list of students, it is updated many times a day with new students, I am looking for a macro that when the second spreadsheet (2010 spreadsheet with tabs for each month) is opened you can run a macro that will search the main spreadsheet for SIN numbers that are not on spreadsheet 2, and add them to the appropriate tab in spreadsheet 2 (2010 spreadsheet with tabs for each month).

For example, If I open the main spreadsheet and add this student
SIN FN LS Start End School Entered
111 222 333 Johnny Cash 09/01/2010 04/30/2011 GUAG 10/15/2010

when I save this new data and I open the 2nd spreadsheet (2010 spreadsheet with tabs for each month) and I run the macro it should see that the entered date is October, therefore it should pull this student's SIN, FirstName and LastName and plug it into the first empty cell (below all other copied data from previously running this macro) into the tab named "October".

I hope this helps clarify what I'm trying to do!

Report •

Related Solutions

Ask Question