How to use data from one sheet to create a birthday calendar in another

**mjpet06** · 08-24-2015, 08:05 PM

Help Sheet.xlsxPlease help,

I have a spread sheet with data of class members (name, birthday, gender, email ect...). I created a new sheet with month headers to organize my students by months (so I know when their birthday is according to month and day).
How can I pull the student's name and birthday from my main data list over to the calendar with the month headers and have it make a list of the students' name and day of birth under the appropriate month?

Any help would be GREATLY appreciated!!

**Pete_UK** · 08-24-2015, 09:27 PM

The following thread has links to several of my calendars:

http://www.excelforum.com/excel-new-...o-a-sheet.html

These will take a list of events and dates from one sheet and transpose them onto a calendar - the same basic principle that you describe. It will be a bit different for birthdates as the birth year will need to be replaced by today's year.

Post a sample file showing how your data is laid out (the FAQ describes how to), and I'll look at it in the morning, as it's getting a bit late here.

Hope this helps.

Pete

How to use data from one sheet to create a birthday calendar in another

LinkBack

Thread Tools

Rate This Thread

Display

How to use data from one sheet to create a birthday calendar in another

Re: How to use data from one sheet to create a birthday calendar in another

Thread Information

Users Browsing this Thread

Similar Threads

Using Userform Data to Create a Calendar

Create calendar on one sheet by pulling dates from another

Create Calendar on Excel data

birthday calendar

How to create a calendar using excel data?

[SOLVED] How can I create a calendar from excel data (schedule)?

Create a birthday list

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions