Trying to get one sheet to populate another with date ranges

**WayneAPeterson** · 11-01-2013, 03:12 PM

roster.jpg workbook.png

Hello,

I am trying to create a workbook that will help me manage summer conferencing on my campus. I have created one sheet that has every room on campus listed on the Y axis and dates between May and September on the X axis (Let's call it sheet A). I also have a separate sheet in the same workbook that has a roster of groups and people with their arrival and departure dates along with the room that they have been assigned (Sheet B).

What I would like to accomplish in the end is to be able to look at Sheet A and see the group's name in the cells of sheet A corresponding to their arrival and departure dates and rooms they are occupying.

I appreciate any help people can give me on this. I just don't know what direction to head in.

Above are some images of the sheets I am working with.

Thanks,
Wayne

**jaslake** · 11-01-2013, 03:22 PM

Hi Wayne

Welcome to the Forum!!

If you'd like Code that's been tested pictures are of little value.

Please attach a sample file that represents what you have. The structure of your attachment should be the same structure as your actual data. Any proprietary information should be changed.

Include in the attachment any code you're currently using (whether it works or not) and an "After" worksheet that demonstrates what you wish the output to be.

To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the "Add Files"... button to locate your file for uploading.
6. This will open a new window File Upload...Click "Select Files"
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the "Upload Files" button and wait until the file has uploaded.
10. Click the "Done" Button.