TL;DR: I need a macro for Excel 2010 that checks across two columns of a named table for two different text values; and if they meet then change the number value in a third column to 0 (zero).
I've just redesigned the stats spreadsheet for work. Having not used Excel in any depth since my GCSEs back in '97, I was able to get my head round the formulas, functions and conditional formatting side of the project; but the last piece of the puzzle is a macro and I don't know where to start (having never used them).
What I'm hoping is possible is to get the macro to check A2 for a specific text value, if it doesn't contain that value then skip to A3. If it does match, then check C2 for a different specified text value. If the C2's value doesn't match, then restart at A3. If it does then the number value in E2 needs to be changed to 0 (rather than blanked, or deleted).
If it helps; the data is formatted as a table, which is named and has column headers.
If it makes any difference I'm using Excel 2010.
I've tried searching on Google for off the peg solutions; but this proved fruitless. (Probably down to the fact I know nothing of macros or VBS, so lack key search words that would help.)
I've just redesigned the stats spreadsheet for work. Having not used Excel in any depth since my GCSEs back in '97, I was able to get my head round the formulas, functions and conditional formatting side of the project; but the last piece of the puzzle is a macro and I don't know where to start (having never used them).
What I'm hoping is possible is to get the macro to check A2 for a specific text value, if it doesn't contain that value then skip to A3. If it does match, then check C2 for a different specified text value. If the C2's value doesn't match, then restart at A3. If it does then the number value in E2 needs to be changed to 0 (rather than blanked, or deleted).
If it helps; the data is formatted as a table, which is named and has column headers.
If it makes any difference I'm using Excel 2010.
I've tried searching on Google for off the peg solutions; but this proved fruitless. (Probably down to the fact I know nothing of macros or VBS, so lack key search words that would help.)
. There is no error handling or whatnot in here but it should give you an idea.
