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