Hello,
Good Day!
I am using this excel formula within the same sheet and working perfectly.
=FILTER(Table1[#All],Table1[[#All],[NAMES]]='AUGUST - 2024'!C15)
But I want to use this Filter formula to take data from other excel file ( not the same). Where should I put the path of the excel file so that I could take data using other file.
Thanks
If you are using FILTER, then your Excel version is NOT 2013. Before se start on this, please update your profile with 2021, 365 or 2024, as appropriate. Thanks.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Profile Updated: I am using Office 365
Thanks
OK. So, a few questions:
1. Which bits of the formula need to reference a different workbook? Is it the data you want filtering or the match criterion?
2. Will the workbook in question be open or closed?
3. What is your environment? Will the workbook be on your machine, or on something like Sharepoint (a networked drive)?
1. In workbook B where the formula is written, i.e, Sam, Sha, Exs (reference) data of row will be filtered from A workbook and put into workbook B separately in 3 sheets (sheet1 sam, sheet2 sha, sheet3 exs)
2. When the data is put on Workbook A, Workbook B will get data from Workbook A according to the Filter function
3. The workbook is on the same machine
1. Means nothing to me - I cannot see the workbook where the data needs to be collated. Please attach a sample.
2. This is not an answer to the question. I asked whether the workbook with the source data would be OPEN or CLOSED? You may not be able to use the FILTER function. Also, structured table references can't be used with closed workbooks. So this matters - A LOT.
3. Good.
Last edited by AliGW; 09-03-2024 at 04:26 AM. Reason: Typos fixed.
Workbooks attached
Please respond to Q2 in post #6. It's crucial to how this is done.
On a daily basis, data will be entered in Workbook A and in Workbook B through Filter formula auto data will be taken from Workbook A.
The question is this. If Workbook B is not open then will it work or Both workbooks should be open.
Thanks
Not as it stands, no. I said this in post #6:If Workbook B is not open then will it work or Both workbooks should be open.
=FILTER(Table1[#All],Table1[[#All],[NAMES]]='AUGUST - 2024'!C15)structured table references can't be used with closed workbooks.
Red = structured table references.
This will work on an open workbook:
=VSTACK('[Workbook A.xlsx]DATA'!$A$1:$E$1,FILTER('[Workbook A.xlsx]DATA'!$A$2:$E$2000,'[Workbook A.xlsx]DATA'!$A$2:$A$2000=TEXTAFTER(CELL("filename",A1),"]")))
It seems to continue working when the source workbook is closed.
You will need to test it properly for yourself.
It will NOT work in a structured table.
Ok thanks
let me check it.
Let me know, please.
Genious!
Its work
thank you soo much
Glad to hear it. Thanks for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks