Macro to multiply a series of numbers by -1 if target cell matches a list

Hi Everyone,

This is my first post in this forum so I would like to thank everyone in advance for helping me out with this problem.

I have a list of accounts with values in them for 12 months in the year. If the account matches a pre-specified list of "revenue accounts" I need to multiply the data in each month by -1.

Based on the attached worksheet, the logic is more clearly stated as "if Column C = one of the values in A4:A14 multiply E:P by -1." Since my data tables have no headers, the operation would start on row 1.

If possible, I would like the "revenue accounts" to be hard coded into the code so that I can apply the macro to divverent workbooks without having to type in the revenue account list and update the references.

Thanks again.

Aaron