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.

Hi, 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 ...? Regards