How would I use vba to capture only the 3/13/18 values and then select that ranges rows to copy to another sheet tab? I would start at cell A2 and have it move down until it is no longer 3/13/18. Because there are times in with the date... it causes a problem... I later remove the times when I reformat them, but the times need to stay in for this part of the process. Please advise and thanks.