Is this data manually entered?

If so, you can still use the suggestion I made at your other post *except*
don't use the in-cell drop down option in data validation.

If someone tries to enter NV for RepNum 20 it'll be rejected.

P.S.

This post contains more info than your other post so I'm not going to follow
the other post anymore.

--
Biff
Microsoft Excel MVP


"MichaelR" wrote in message
...
Hi,

Could someone please give me some suggestions for how to do the following:

I have a table that summarizes all of my past sales data for each of my
reps. The columns look like this:

RepNum Product State Months (1) Months (2)... Months (12) Total
20 XYZ NM $150 $700 .... $50
Sum(Months)
20 XYZ AZ $200 $900 .... $100
20 XYZ NV $150 $0 .... $0
...

The problem is that there are some entries that were mistakes because a
particular sales rep doesn't sell in a certain state. In the example
above,
rep 20 doesn't really sell in NV so that $150 are a faulty entry and so I
want the total column to show $0 and not $150.

I have a table named repStates that lists the Rep Number (multiple times)
on
each row of the first column and then lists all of the States in the
second
column (one to each row). The table looks like this:

RepNum STATE
20 AZ
20 NM
30 NY
30 NJ
...

Any ideas for how to use excel to do what I am trying would be hugely
appreciated.

Thanks,
Michael