filtering multiple linked columns

**cbrow236** · 02-10-2014, 08:17 AM

hi does anyone know if it is possible to filter on a column in one tab and then the same column which linked in a few other tabs also filters on the same thing? for instance the column is country so if you choose america in the first tab the country column in the other tabs also filters on amercia?

**Fotis1991** · 02-10-2014, 08:31 AM

I hope this to be useful for you!

http://www.excelforum.com/excel-tips...-formulas.html

**cbrow236** · 02-10-2014, 09:00 AM

thanks fotis1991 i have tried to put in the formulas as in the link but cant seem to get them to work in my spreadsheet

**Fotis1991** · 02-10-2014, 09:18 AM

Did you see the 2 helper&hidden columns in sheet1?

**cbrow236** · 02-10-2014, 09:20 AM

i did but still didnt really understand it, sorry im not great with excel.

**Fotis1991** · 02-10-2014, 09:22 AM

The the only way is to upload a small sample workbook.

**cbrow236** · 02-10-2014, 11:38 AM

the data is classified so i have tried to put a sample showing a few tabs where the first three colums link through the other tabs and are then followed by data specific to that tab