is it possible to filter two tables column at once !?

[anto5]

dear all,

i am using two tables in an excel file as following:

- table 1 consists of 3 columns as following:
* column one is Date of purchase
* column one is Product Description
* column one is Product Cost

- table 2 consists of 2 columns as following:
* column one is Date of month closing
* column one is the total amount for the month date

my question is the following, when i filter on the date column of table 1 and choose the dates that belongs to January 2018, is it possible that table 2 will filter automatically on the same criteria and shows only dates that belongs to January 2018 ?

I attached a small sample of my data.

thank you

P.S. i am using Ms. Excel 2013

[AliGW]

Welcome to the forum!

Your profile says Excel 2010 - please would you update this to show what you are actually using?

[anto5]

First Thank you,

i am sorry if it confused you but on my PC i have Ms. Excel 2010 and i work on it all the time but the above question is for 2013 as i am working currently on someone's else PC for this project and he has Ms. Excel 2013 that's why i mentioned the version at the end...

but if i have to change my profile to 2013 i will change it no problem

[AliGW]

You can show both versions in your profile. Members will use what's in your profile as a guide when offering solutions.

[anto5]

oh i thought we only have to chose one version , thank you for the info

[JeteMc]

One would think that it is possible to tie multiple tables to a filter/slicer, however the third post of this thread seems to show that it isn't.
Attached is a solution of sorts. Two pseudo tables (ranges) are populated based on the data in the two tables, and the drop down date value in cell I2
1) The formula for the 'Raw Product Purchase' range is:

Please Login or Register  to view this content.

2) The formula for the 'EOMonth Balance' range is:

Please Login or Register  to view this content.

Let us know if you have any questions.