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" <[email protected]>
wrote in message
news:[email protected]...

 

[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" <[email protected]>
wrote in message
news:[email protected]...

 

[Anne Troy]

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

 

[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]

Thank you all so much for the quick responses! I tried highlighting al
the tabs, and when i do that I am unable to choose validation of th
data pull down menu. I have tried also to copy the validation from on
worksheet to another and when i do that, i get a pull down menu but th
list is not there and there is some sort of error. ??? What am I doin
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

 

[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

 

[nicolebelle]

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