Thread: Data validation forces entry in a range of cells.

Hi

Not sure it my description gave much of a clue.
I have a simple accounts sheet in Excel.
I do not as yet know VB. Just getting a handle on functions.

I have a column (E) of numbers, amounts paid out of the bank. I have a category column (G)which is populated with categories using data validation. I have columns to the right which are named as in the data validation options. Is there an automatic way that once the category has been chosen the amount be automatically entered in the appropriate column (drawings in the attached example) and in the same row P2.

Thanks to all who read this and a special thanks to anyone who has any suggestions as this would make what I am doing have less errors.

Mark

I am using excel 2010.

Fabulous. Such a small function so elegantly employed. Thanks a million