This is more complicated than it looks.

Here is what I have.
I have a Master List with 3 colums The first column labeled location has a pull down menu with about 20 different options. The middle column labeled issues is just for text entry. The third column labeled contractor is another pull down menu with 18 options on it. I also have 18 other sheets within the workbook that correspond to the third column pulldown menu.

Heres what I need.
I would like to be able to enter info from columns one and two and be able to choose an option from column three and the info from columns one and two go to the corresponding sheet.

I dont know if this is possible without writing a hole new program but if it is any help would be greatly appreciated..

Get kind of creative with CELL, INDEX, MATCH, ISNA, OFFSET and IF...

Oh, ok, I got kind of creative with them and came up with something that I
believe will do what you're hoping for. Not perfect, will leave gaps in rows
on the sheets the data is transferred to, but using Data | Auto Filter and
choosing [Non Blanks] will close up those gaps for better appearance.

I borrowed some code from Rodney Powell's site to a self-maintaining list of
sheet names to use as the data validation list and set the list up with
CELL() formula to determine the names of the sheets in the workbook. So the
list will automatically update sheet names even if a user changes them. You
only have to mess with the list when you first set it up and when you add new
sheets to the workbook.

I tried to explain my formulas for pulling the data from the main source
data sheet to the others, but the two formulas used there fall into the
Really Ugly category and I probably didn't do a good job of it.

Anyhow, the workbook is available here:
http://www.jlathamsite.com/uploads/
CopyToOtherSheetsByChoice.xls
(that should all be one line address). There is no macro code in the
workbook, it's all done with formulas. My contact info is on one of the
worksheets.



"dollarbill79" wrote:

>
> Here is what I have.
> I have a Master List with 3 colums The first column labeled location
> has a pull down menu with about 20 different options. The middle column
> labeled issues is just for text entry. The third column labeled
> contractor is another pull down menu with 18 options on it. I also have
> 18 other sheets within the workbook that correspond to the third column
> pulldown menu.
>
> Heres what I need.
> I would like to be able to enter info from columns one and two and be
> able to choose an option from column three and the info from columns
> one and two go to the corresponding sheet.
>
> I dont know if this is possible without writing a hole new program but
> if it is any help would be greatly appreciated..
>
>
> --
> dollarbill79
> ------------------------------------------------------------------------
> dollarbill79's Profile: http://www.excelforum.com/member.php...o&userid=36212
> View this thread: http://www.excelforum.com/showthread...hreadid=560052
>
>

Went and grabbed the sample file you uploaded and modified it and have put
the modification here:
http://www.jlathamsite.com/uploads/S...nchlist_V2.xls

Explanations from the previous file apply, I've added some short comments
into this workbook but they refer to the other one also, so you may want both
to make sense of it all.

Hope this helps.

"dollarbill79" wrote:

>
> Here is what I have.
> I have a Master List with 3 colums The first column labeled location
> has a pull down menu with about 20 different options. The middle column
> labeled issues is just for text entry. The third column labeled
> contractor is another pull down menu with 18 options on it. I also have
> 18 other sheets within the workbook that correspond to the third column
> pulldown menu.
>
> Heres what I need.
> I would like to be able to enter info from columns one and two and be
> able to choose an option from column three and the info from columns
> one and two go to the corresponding sheet.
>
> I dont know if this is possible without writing a hole new program but
> if it is any help would be greatly appreciated..
>
>
> --
> dollarbill79
> ------------------------------------------------------------------------
> dollarbill79's Profile: http://www.excelforum.com/member.php...o&userid=36212
> View this thread: http://www.excelforum.com/showthread...hreadid=560052
>
>

Hey thanks for all the help....this is going to make my job even easier.....

Hey thanks for all the help....this is going to make my job even easier.....