Forum Discussion
MacJones10
Dec 28, 2022Copper Contributor
Filter Function Data Linking
I am using the filter function below to take all jobs "Won" from my main data sheet. Columns (B-P) are a part of the Filter function, I want to keep track of the dates I send the invoice to the clients as you can see in column (R). However, every time a new row is added in the filtered portion of the sheet, The nonfiltered portion of this sheet columns R-V don't move with the updated filtered data. My question is there a way to link the data so the correct date moves with the correct invoice number and job
- mdoddsCopper Contributor
I have found that this function works well and should solve your issue, however the one thing it doesn't do is make hyperlinked data remain as a hyperlink, that's something I'm trying to resolve. So your data would be in a tab that I'm calling Data[Employee ID2] the Data is the name of the tab while the Employee ID2 is the column label.
=FILTER(Data,ISNUMBER(SEARCH($B$3,Data[Employee ID2]))=TRUE,"Not match found")
- LorenzoSilver Contributor
> 60 views so far. This probably means nobody understand the issue. To helps us help you:
#1 Could upload & share, i.e. with OneDrive or any other file sharing service, a sample representative workbook (remove sensitive data if any) that includes your formula(s)?
#2 What version of Excel do you run & on which Operating System (Windows, MacOS...)?
- MacJones10Copper Contributor
Hello Lorenzo Ill work on getting a copy of the spreadsheet. I am using the new version of Excel 365. THe function I am using is the new Filter function =Filter() to pull the specific data I need from the main page into the new sheet.