Mastering Excel Macros: Object Variables (Book 6) by Mark Moore

Author:Mark Moore [Moore, Mark]
Language: eng
Format: epub
Tags: Excel macros
Published: 2015-02-17T22:00:00+00:00

Now you need to get the Item # and Salesperson. For the Item # you use the LEFT function and to derive the salesperson you use the same logic with INSTR but look for the salesperson’s name instead. There are only three salespeople, Lisa, Tom and Crystal.

Pseudocode Step 4 - If salesperson is Tom, skip the row

Here we are going to get crafty. Instead of skipping a row when it is Tom, we are going to process the row when it is NOT Tom. Add the IF statement to your code (I’m only going to put the new code from now on, at the end I will put the complete code):

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.