Validation Help
 

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!!!:eek: ) 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

Validation Help
 

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"
wrote in message
...

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!!!:eek: ) 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

Validation Help
 

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"
wrote in message
...

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!!!:eek: ) 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

Validation Help
 

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

"Peo Sjoblom" wrote in message
...
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"
wrote in message
...

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!!!:eek: ) 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

Validation Help
 

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!!!:eek: ) 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!

Validation Help
 

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
------------------------------------------------------------------------
nicolebelle's Profile: http://www.excelforum.com/member.php...o&userid=28847
View this thread: http://www.excelforum.com/showthread...hreadid=485968

Validation Help
 

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

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

Validation Help
 

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 SpecialAllOKEsc.


Gord Dibben Excel MVP

On Thu, 17 Nov 2005 12:47:40 -0600, 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???

Validation Help
 

:) 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?:confused: Thanks
again!!!


--
nicolebelle
------------------------------------------------------------------------
nicolebelle's Profile: http://www.excelforum.com/member.php...o&userid=28847
View this thread: http://www.excelforum.com/showthread...hreadid=485968