Mark,

Take a look at Data Validation at
http://www.contextures.com/xlDataVal01.html

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Mark King" wrote in message
...
Hi,

Is there any way I can have a drop down box with four selections in each
and
every cell from ranges (G5:G30).

Once a user makes a selection the contents are to be placed in their
appropriate cells that they were selected from.

Many thanks for your help in advance,
Mark