5 Replies Latest reply on May 14, 2018 2:49 PM by Shinichiro Murakami

    Using filtered data from one sheet on a separate unfiltered sheet

    Steve Marsh

      I am trying to take the information shown in the 4th column (Customer ID) shown in the attached picture and use it to find different data on a new, unfiltered sheet. For instance, I want to take JENN3078, FIRS7149, GLEN1006, etc to go to another sheet and find whether those customers have placed an order since the date shown in column 2. Since the data on this sheet has already been filtered down to just one week from X months ago, the information that I am trying to find is no longer there. Is this possible? If so, how?