Populating Data based on Drop Down Menu

[clarky5]

Hi,

I have a file where on a tab called Exec Summary you use a drop-down menu to select an expense type, say Travel in cell A1. This drives a VLOOKUP to pull through the name of a Person, say Person A.

On a tab called spend type, I am then looking to pull through the Level 1 and Level 2 spend types relating to Travel into columns A & B, and then I will VLOOKUP to pull in the data by departments. Data table is laid out as below but goes to Column R and row 760

[TABLE="width: 500"]
<tbody>[TR]
[TD]Sponsor[/TD]
[TD]Level 1[/TD]
[TD]Level 2[/TD]
[TD]Marketing[/TD]
[TD]Sales[/TD]
[/TR]
[TR]
[TD]Person A[/TD]
[TD]Meetings & Events[/TD]
[TD]Agency Fees
[/TD]
[TD]10[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]Person A[/TD]
[TD]Meetings & Events[/TD]
[TD]Hotels[/TD]
[TD]15[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]Person B[/TD]
[TD]Market Reseach[/TD]
[TD]Primary[/TD]
[TD]50[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]Person B[/TD]
[TD]Market Reseach[/TD]
[TD]Secondary[/TD]
[TD]75[/TD]
[TD]0[/TD]
[/TR]
</tbody>[/TABLE]


What I am looking for is an easy way to populate the Level 1/Level 2 column data, when the drop menu changed expense type. Assuming its a Macro, but struggling to get one to work.

Many thanks
Graham