Copying Dropdown boxes

[Col]

Dear all,

I'm sure I've done this before successfully but can't remember how to do it!

I have a sheet with two tabs, one of them is just a repeated group of cells
with eight drop downs over cells F4 to F11 which are the cells into which
they link. The group is then repeated numerous times down the tab.

The second tab is the link for the contents of the drop down and covers
cells A1:A10.

What I wish to do is increase the number of options in the dropdown by four
meaning the drop down data will now be A1:A14, I've changed the first group
of drop downs on the first tab to reflect this but am having difficulty
copying them down the tab as I don't wish to manually have to change 60-70
drop downs.

I've tried copying/pasting, selecting the range and holding CTRL to copy
that way, I've also taken out the absolute ($) signs, but nothing works. I'm
using Excel 2000 but it may have been a previous version of the software
when I last did it and this may be the reason why it worked last time.

Anyone have an idea how I can do this the easy way!

Thanks for any advice,

Colin.

 

[Bob Phillips]

Select all the cells, and go into DV and then just change that formula once.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

 

[Col]

Select all the cells, and go into DV and then just change that formula once.

--

Please forgive my ignorance but what does DV mean, if it refers to Data
Validation then yes it works for the cells but not the 'Control' tab within
'Format Control' on the drop down boxes themselves.

Regards,



Colin.