Validation Help

[nicolebelle]

Hi Everybody--i have a 50 +/- tabbed worksheet, I need each worksheet to have the same headings (there are about 10 headings) underneath each heading i have my drop down list (validations) that people need to choose from. i need to format my whole gigantic worksheet like this, but right now am only doing it 1 at a time (which is taking forever!!! ) Does anybody know how to do this?? this is my first time and there has got to be an easier way...any help would be greatly appreciated!! thanks!

[Anne Troy]

First, can't you create a sheet and copy it?
If not...
Second, can't you copy the rows?

************
Anne Troy
VBA Project Manager
www.OfficeArticles.com

"nicolebelle" <nicolebelle.1ynlbb_1132251603.1702@excelforum-nospam.com>
wrote in message
news:nicolebelle.1ynlbb_1132251603.1702@excelforum-nospam.com...
>
> Hi Everybody--i have a 50 +/- tabbed worksheet, I need each worksheet to
> have the same headings (there are about 10 headings) underneath each
> heading i have my drop down list (validations) that people need to
> choose from. i need to format my whole gigantic worksheet like this,
> but right now am only doing it 1 at a time (which is taking
> forever!!! ) Does anybody know how to do this?? this is my first
> time and there has got to be an easier way...any help would be greatly
> appreciated!! thanks!
>
>
> --
> nicolebelle
> ------------------------------------------------------------------------
> nicolebelle's Profile:
> http://www.excelforum.com/member.php...o&userid=28847
> View this thread: http://www.excelforum.com/showthread...hreadid=485968
>

[Peo Sjoblom]

If you select all sheets all the things you do in one sheet will be done in
all the sheets, don't forget to ungroup the sheets when you are done


--

Regards,

Peo Sjoblom

"nicolebelle" <nicolebelle.1ynlbb_1132251603.1702@excelforum-nospam.com>
wrote in message
news:nicolebelle.1ynlbb_1132251603.1702@excelforum-nospam.com...
>
> Hi Everybody--i have a 50 +/- tabbed worksheet, I need each worksheet to
> have the same headings (there are about 10 headings) underneath each
> heading i have my drop down list (validations) that people need to
> choose from. i need to format my whole gigantic worksheet like this,
> but right now am only doing it 1 at a time (which is taking
> forever!!! ) Does anybody know how to do this?? this is my first
> time and there has got to be an easier way...any help would be greatly
> appreciated!! thanks!
>
>
> --
> nicolebelle
> ------------------------------------------------------------------------
> nicolebelle's Profile:
http://www.excelforum.com/member.php...o&userid=28847
> View this thread: http://www.excelforum.com/showthread...hreadid=485968
>

[Anne Troy]

Duh. Leave it to me to forget the obvious.
************
Anne Troy
VBA Project Manager
www.OfficeArticles.com

"Peo Sjoblom" <terre08@mvps.org> wrote in message
news:uDB%230S66FHA.2036@TK2MSFTNGP14.phx.gbl...
> If you select all sheets all the things you do in one sheet will be done
> in
> all the sheets, don't forget to ungroup the sheets when you are done
>
>
> --
>
> Regards,
>
> Peo Sjoblom
>
> "nicolebelle" <nicolebelle.1ynlbb_1132251603.1702@excelforum-nospam.com>
> wrote in message
> news:nicolebelle.1ynlbb_1132251603.1702@excelforum-nospam.com...
>>
>> Hi Everybody--i have a 50 +/- tabbed worksheet, I need each worksheet to
>> have the same headings (there are about 10 headings) underneath each
>> heading i have my drop down list (validations) that people need to
>> choose from. i need to format my whole gigantic worksheet like this,
>> but right now am only doing it 1 at a time (which is taking
>> forever!!! ) Does anybody know how to do this?? this is my first
>> time and there has got to be an easier way...any help would be greatly
>> appreciated!! thanks!
>>
>>
>> --
>> nicolebelle
>> ------------------------------------------------------------------------
>> nicolebelle's Profile:
> http://www.excelforum.com/member.php...o&userid=28847
>> View this thread:
>> http://www.excelforum.com/showthread...hreadid=485968
>>
>
>

[Roger Govier]

Hi Nicole

Click on the first worksheet tab, hold down shift button and click on the
last worksheet tab. This will Group them and it will say Grouped at the top
of the screen.

Now, anything you do to any sheet, will be replicated across all others.
When you have finished, click on any single tab to Ungroup them.

Regards

Roger Govier


nicolebelle wrote:
> Hi Everybody--i have a 50 +/- tabbed worksheet, I need each worksheet to
> have the same headings (there are about 10 headings) underneath each
> heading i have my drop down list (validations) that people need to
> choose from. i need to format my whole gigantic worksheet like this,
> but right now am only doing it 1 at a time (which is taking
> forever!!! ) Does anybody know how to do this?? this is my first
> time and there has got to be an easier way...any help would be greatly
> appreciated!! thanks!
>
>

[nicolebelle]

Thank you all so much for the quick responses! I tried highlighting all the tabs, and when i do that I am unable to choose validation of the data pull down menu. I have tried also to copy the validation from one worksheet to another and when i do that, i get a pull down menu but the list is not there and there is some sort of error. ??? What am I doing wrong???

[Debra Dalgleish]

What is the source for the validation list? Maybe you could use a named
range, as described here:

http://www.contextures.com/xlDataVal01.html

nicolebelle wrote:
> Thank you all so much for the quick responses! I tried highlighting all
> the tabs, and when i do that I am unable to choose validation of the
> data pull down menu. I have tried also to copy the validation from one
> worksheet to another and when i do that, i get a pull down menu but the
> list is not there and there is some sort of error. ??? What am I doing
> wrong???
>
>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

[Gord Dibben]

nicole

You cannot group sheets and create a DV drop-down as you have found out.

On sheet1 if you type the list into the dialog box(comma de-limited) you can
copy to all the other sheets.

OR

If you have a named range for the list and use that named range in the list
dialog........ =TheList

You can copy the DV to all the other sheets.

In either case copy the DV cell from first sheet.

Select sheet2 then SHIFT + Select last sheet and Paste Special>All>OK>Esc.


Gord Dibben Excel MVP

On Thu, 17 Nov 2005 12:47:40 -0600, nicolebelle
<nicolebelle.1ynmpa_1132253404.2551@excelforum-nospam.com> wrote:

>
>Thank you all so much for the quick responses! I tried highlighting all
>the tabs, and when i do that I am unable to choose validation of the
>data pull down menu. I have tried also to copy the validation from one
>worksheet to another and when i do that, i get a pull down menu but the
>list is not there and there is some sort of error. ??? What am I doing
>wrong???

[nicolebelle]

Great!! that helped me so much...thank you guys...my gigantic matrix is really coming along now...but i have another question...how can I protect my workbook so that my formatting and printsettings can't be changed by others, I would like to limit those using the workbook to only the drop down lists...is this possible? Thanks again!!!