Combo box that fills out an entire sheet?

**charliemopps** · 11-05-2009, 04:18 PM

I was wondering if anyone has an example of how to do this?

I have a schedule that we maintain in Excel.
Currently we are on an 8 week rotation, so the person has 8 versions of the spreasheet (ugh) and she cuts and pastes data from the correct template into the current weeks schedule. It's very cumbersom.

What I'd like to do is have all 8 templates as hidden sheets in the current workbook, and then have a dropdown that would automatically fill out the sheet for her. So she'd just pick "Template1" and Vioala! The entire sheet is filled out for her.

Anyone have a suggestion? or maybe an example sheet? Just something to point me in the right direction.

**royUK** · 11-05-2009, 04:21 PM

Without seeing what your templates are we can only guess. maybe VLOOKUP would do it

**charliemopps** · 11-05-2009, 04:32 PM

It's just a table with Dates at the top, Tasks to the left and names in the middle.

Like:

Please Login or Register  to view this content.

I don't think I could use Vlookup.
I basically what the dropdown to have a list of 8 sheets. If a sheet is selected it would make the current sheets data (the names) copy to the current sheet. Also, the names can not be based on a formula. Sometimes people are out sick and someone needs to be hand entered.

**royUK** · 11-05-2009, 04:51 PM

As I said, without seeing the workbook we would be guessing, which is a waste of time

**charliemopps** · 11-05-2009, 05:09 PM

Well, you're certainly helpful. I'll be sure not to bother you anymore. Hate to waste your time.

**royUK** · 11-06-2009, 02:47 AM

You can't be bothered to help yourself, we're not mind readers. Consult a crystal ball

You couldn't even get a paid solution on the flimsy detail that you have posted