Calendar issue

**Link** · 04-02-2008, 12:06 PM

Hello guys,

I have to create a work shift attendance plan system.I have created a calendar template in excel.In 'every business day' cell there are 6 combo boxes (drop down list).Every employee can choose if he is on AM or PM shift. For example: Gabriel - AM, Tomas - PM.Employees make his attendance plan for entire month.

I would like to ask you for a help.I need to solve this:

I need to create an other worksheet.This will be the 'Front page'.I would like to show here the actual attendance for every day.For example according to the calendar on 4th of April there should be Employee1 - PM, Employee2 - PM, Employee3-PM, Employee4 - PM, Employee5 - AM, Employee6 - AM. So I don't need to see the entire month, just the actual day or week. I would like to create a system which automaticaly load information from attendance calendar and show it in the Front page.

Can you help me with this please?

Thank you.

**WinteE** · 04-02-2008, 01:14 PM

Please post what you've got so far, I think this can be done by using VBA.

**Link** · 04-08-2008, 05:04 AM

Ok, I'm attaching an example file...

**WinteE** · 04-08-2008, 01:36 PM

Link,

I took a look at your file and came to the conclusion that you don't make it easy to yourself. The listboxes you're using exclude the use of almost all Excel functions.

Instead of using this Form listboxes you better use the validation listboxes. The values you select there are stored in the cells on the sheet and can be used in Excel functions like VLOOKUP() etc.

There's an example on my site about how to use validation listboxes.

Erik