Macro needed to change data based on other data

[M.Sigma]

Hi All,

Daily I'm downloading a report that has many customer codes, in coulmn F, in coulmn B the area code & coulmn C for Rep code

I need a macro that will look for the following customer codes & change the area code & for some the Rep code for others which is in the same row of the customer code.

Note that these data are fixed in coulmns but not in rows & can be in any row.

Example.

CUSTOMER AREA REP
COULMN F COULMN B COULMN C

12Q00001 EDG
12Q00002 EDG
27I00005 045
27A00046 045

Based on the code in coulmn F, I need EDG to be replaced by QDG & 045 to D045.

I have a file of more than a thousand rows, i need a macro for the example & i will amend it for the remaining data.

I appreciate your usual help.

 

[M.Sigma]

this is the example




http://www11.0zz0.com/2011/07/18/08/256886171.jpg

 

[M.Sigma]

Is this difficult for you? I don't think, or maybe you didn't get what i'm trying to say.

Please somebody help.

thanks