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
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