So here is what I need to have happen. Excuse me the code and excel file I have attached are seperate to prevent user data on the web I created the test file based from the Quickbooks data file I use for multiple excel macros.
I am trying to automate the process of creating a dynamic list based upon the test file attached. I want it to find every instance of the word "Bill Pmt -Check" in column B and copy the business name once it finds the word "Bill Pmt-Check" that is in column H of the same row. I would like it to continue until it cannot find another Bill Pmt-Check.
Here is what I have tried so far and I think it might be bad programming: ie I have it first searching for the number of instances of the word Bill Pmt -Check and recording that value in a cell. Then it stops copying business names once it hits that value of the cell aka the number of businesses it copies stops when it reaches the total NUMBER of businesses.'
This script is not working as it records the value 0 still:
Bookmarks