Hello,
I cannot figure this out.
Please Login or Register to view this content.
My goal is to do the following:
1. Scan through each value in column AA from 200 to 2 for the word REMOVE. This works
2. If I find one, use offset to select that activerow's cell C, the sales order #. This works
3. Run that sales order number through column C of the RegExpiry tab, to see if it's already in there. This kind of works? maybe?
4. If it exists - stop, don't copy anything, and go back to the start minus 1 row.
5. If it doesn't exist, continue on to copy the order into that sheet.
I'm getting lost with all the IFs and embedded IFs and FORs...
Bookmarks