May 26 2021 05:17 PM
Is there a way to create a formula where data gets pulled into another sheet, within the same workbook, if and only if certain criteria are met?
For instance, I have a master tab where information is inputted. There is a second tab where only certain information pertaining to that tab will be pulled over if and only if it meets the criteria. If Also as the master tab gets updates so will the other tab.
Only if there is a re-evaluation date for customer x, then customer x's info gets pulled over to the re-evaluation tab, if customer x does not have a re-evaluation date then nothing gets pulled over. Further, as more new customers get entered into the primary data tab, if they have a re-evaluation date then they get automatically pulled over to the re-evaluation tab.
May 26 2021 07:14 PM
@Detlef Lewin that would have been amazing, unfortunately I don't have that version of Excel
May 26 2021 08:24 PM