Auto populating a map with numbers

[RodneyW]

I have a chart with a few thousand rows. The first column lists the state, the second column has a number, one, two or three digits. I'll have another tab listing all 50 states and using a SUMIF formula will show the total for each state.

The goal is to have a map of the US with each state outlined and the numbers from the SUMIF tab would populate the appropriate state. Each time the numbers on the first tab are updated, I need it to refresh on the map.

Any direction you can point ,me?

Thanks in advance

 

[RodneyW]

Any ideas?