Using Macros with Data Validation

Hi all,

I have set up a Data Validation List with a table beside it. What I want to do is input Data in the table that is linked to the header selected in the list.

The problem is, whenever the header in the list changes, the data remains the same, so I have since had to give each header its own worksheet as opposed to using the list.

I am sure there is a way to keep it all in one sheet. Can anyone help?
Sam

Thank you for your reply.

The Data Validated list reads:
Hospital Based Pathways
Integrated Care
Corporate
Children, Young People & Families
Estates & Facilities

Beneath this, I have a table that has April 2013 to March 2014 along the coloumns, and Activity & Cost on the rows:

2013/14
Hospital Based Pathways

Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar
Activity 245 640 455 547 548 544 495 602 594 601 608
Cost 549

Whenever I change the Hospital Based Pathways to another header from the list, I want the figures to be removed for me to put in new data.

Any better?

Please see attached.

When I change the header (the Data Validated Cell), I want the data to disappear, allowing me to put in a new set of data for the header now selected.

SO it currently has data for Cancer & Core Functions, I want to select Corporate, and be able to put in new data.