When running my VBA program for the batch category, my macro only outputs one customer. I realized that there are spaces on the first 2 customers on the “Batch Input” tab. I don’t know how to make my program ignore those spaces since I can’t just delete those.
There is a function in excel that will go down to the first row of a new section (for example, if there is 10 rows of filled cells, it will go down to the 11th cell if it’s blank, or if there is 6 rows of blank cells, it will pop down to the 7th cell if it’s filled). The command is found in the book and will help solve this issue.
Hint: It has something to do with End (usually it’s down, but it could be left, right, or up) and sometimes activecell.