Thank you Poizhan! I was looking at the code, but couldn’t see how it scans for the pair of values, 0 and 1.
Sorry if I wasn’t very clear. I would like to scan Column H for a pair of numbers, 1 followed by 0. If the code finds a pair, it will take the date in Column G, on the same row where the 0 is, and copy that to the next available row, Column C (Starting at C4). The code will scan the entire Column H for the pair (1 to 0) and copy the dates to Column C.
If you can help me again, I’ll appreciate it very much. Thanks again Poizhan!
Bookmarks