Need some help with a macro problem.
In B1 I have a COUNTA formula which gives me the number of items remaining after a task is performed. It was suggested I do this by a board member which is a great idea. My problem is I don't know how to write the code. So if anyone can help I would greatly appreciate it.
At some point in my routine I will run out of data to process.
I use the Data filter in Col "P".
When the Value in B1 = 0, end the program (GOTO End Sub ??) , if not continue. How do I write the code for this step?
Thanks for your help,
Zac
In B1 I have a COUNTA formula which gives me the number of items remaining after a task is performed. It was suggested I do this by a board member which is a great idea. My problem is I don't know how to write the code. So if anyone can help I would greatly appreciate it.
At some point in my routine I will run out of data to process.
I use the Data filter in Col "P".
When the Value in B1 = 0, end the program (GOTO End Sub ??) , if not continue. How do I write the code for this step?
Thanks for your help,
Zac