As above really...

I have got as far as creating drop down lists for a cell, but I would
like to fill cells to the right of that cell depending on what value I
chose in the first cell. I hope that makes sense?!

For example if I choose 'X' in cell A1, then A2 fills with 'Y' and A3
fills with 'Z'.

I'm sure this is straight forward.. but can't find it...

Any help would be appreciated!

Richard.