Multiple Row Filters in Same Sheet

I was working on my data sheet and countered with one problem

I required filters in two row ranges on being specific I want the first filter to be placed for data range from Row no. 1 to 200 and the second one I want for Row no. 210 to 350.

So I try to do it with filter options that are available in Excel 2007 & Excel 2010 but not getting it but whenever I put the filter on second range first filter goes disappear so with the help of search on various options I got the answer for this problem. And it is here for your help also this we can do without macros

First Go to Insert ribbon in MS Excel 2007
Click on Table A "Create Table" Window will open Select the data range and Mark My Table has headers option
And repeat the same function for another range you will get the desired results.

Regards
Hemant

for more you can refer this book.

https://amzn.to/2SFxDv4

Opening A Link Workbook

So many times we use another workbook data as a reference data by linking files to open those link or source files from the main file we could use following method

Go to Edit Menu open link and click on Open source

Or We can use Shortcut Key for this that is Ctrl+[

Regards
Hemant