Forum Discussion
Amy_Sljivar
Dec 06, 2023Copper Contributor
Excel - Pull information from one sheet to another based on a date value
Hello, I hope I can word this correctly. I would like to import data from one sheet to another based on a date value within 30 days of today.
Basically I have a contacts spreadsheet with a list of suppliers and their contract renewal date. I would like to have another sheet within the document that only displays Contracts that are within 30 days of their expiry date. But I would need all the cells from that Row to pull through. Hope that makes sense and thankful for any advise received 🙂
1 Reply
Let's say that the first sheet is named Contact Sheet, with data in A2:W1000, and renewal dates in D2:D1000.
On another sheet, enter the following formula in a cell:
=FILTER('Contact Sheet'!A2:W1000, 'Contact Sheet'!D2:D1000<=TODAY()+30, "")