Maco help needed !

[eddy]

I could do with some help scripting a macro.

This is what I would like to do:-
I have a sheet with Product P/Nos in Col C Rows (13 to 39)
I have a VAT figure, in Col F Rows (13 to 39) for each item.
If certain P/Nos are listed in Col C then I want certain other P/Nos to have the VAT figure set to 0.

e.g If P/Nos SOFTEX100, OR SOFTEX200, OR SOFTEX300 (list may grow) are listed THEN IF EITHER NOTMAX400, OR NOTMAX500, OR NOTMAX600 (list may grow), are listed THEN change the VAT of these items to 0

All help would be appreciated

 

[eddy]

Yes, great result. Hope I can repay you someday. It's all amalgamated into another bit of code and it runs like a dream, but maybe more importantly the look up table makes it easy for others to add to the conditions. This is a code snippit for the collection book! Its now time for bed here, goodnight.

Regards Eddy