This Month's Birthdays in Excel

Microsoft Excel 2007 home and student
November 2, 2009 at 15:22:15
Specs: Windows XP
Trying to create a birthday list in excel, below is how I was thinking of formating it:

1	Birthdays!!											
2			1	2	3	4	5	6	7	8	9	10
3	Jan	Student:										
4		DOB:										
5	Feb	Student:										
6		DOB:										
7	March	Student:										
8		DOB:										
9	April	Student:										
10		DOB:										
11	May	Student:										
12		DOB:										
13	June	Student:										
14		DOB:										
15	July	Student:										
16		DOB:										
17	Aug	Student:										
18		DOB:										
19	Sept	Student:										
20		DOB:										
21	Oct	Student:										
22		DOB:										
23	Nov	Student:										
24		DOB:										
25	Dec	Student:										
26		DOB:										

My guess is there is two ways to do it. One would be to create the conditonal paste and have DOBs in January be the criteria (just for the January birthdays). Then do the same for Feb. March etc.

The 2nd way, I think, is to link the birthday page to the names and DOBs of my main datebase and run a custom filter. I think I would rather the first solution so I would not have to write another macro to make the worksheet autorun the filter.

Hope this made sense.

See More: This Months Birthdays in Excel

Report •

November 2, 2009 at 17:10:43

To help on this I have a few questions.

1. What is your conditional paste - ('One would be to create the conditonal paste'), please post sample.
2. How did you get the DOB into the spreadsheet ('...have DOBs in January be the criteria ...').
3. What is the structure and content of your database.
4. Is your database in Excel, another DB or a text file or ...?


Report •
Related Solutions

Ask Question