I am struggling to create a macro that will allow me to change the rate table used for a resource based on a value found in a custom field. What I am attempting to do something like the following pseudo code(please don't laugh as I have not programmed for more than a decade.)

For each row in the Resource Sheet

Switch

Case Text1 = "On Site" set the Cost Rate Table to A for the Resource

Case Text1 = "Client Offices" set Cost Rate Table to B for the Resource

Case Text1 = "Our Offices" set Cost Rate Table to C for the Resource

EndSwith

EndFor

Thanks in advance to tacking a look at this. I know this is so "third grade" for many of you. But, I am stuck and getting this to work means mucho brownie points with my boss.(smile)

- John