MTS to MP4 Conversion : [Solved] Advanced filter on a different sheet

Advanced filter on a different sheet

I have a table which is something like...Region, City, Store, Week, Sales, Year on Year Growth, Rank within City, Rank within Region.
(some of the fields have formulas)

On another sheet, I want to have filters where user can select any region and data matching the filter would be made available on that sheet.
I would also like to give the user the option to sort the 'filtered' data on any of the columns.

Please let know how i could achieve this

Nikhil

Solutions to the Problem Advanced filter on a different sheet

Download Error Fixer for Free Now

Hi,

From the title of your question, i assume that you know how to use Advanced Filters in MS Excel. So try this

1.
On the other sheet (say sheet2), enter text Region in cell C1. Have assumed that text Region is in your source data table (say sheet1) as well
2.
In cell C2 of sheet2, enter the specific region
3.
Click on any other cell of sheet2 and go to Data > Sort and Filter > Advacned > Copy to another location
4.
In the List range, select the source data range (first row is the header row) in sheet1; and
5.
In the criteria range, select C1:C2 of sheet2
6.
In the Copy to box, select F1 of sheet2

Click on OK.

Use the System File Checker tool to repair corrupted or missing system files:

Click Start.
Type cmd, and then press CTRL+SHIFT+ENTER to open the elevated command prompt (I.e. Command prompt with administrative rights).
The User Account Control window should appear, be sure that the action it exhibits is correct, and then press the Continue button.
Type or copy paste the below command line into it without quotes:
"Sfc /scannow"

Another Safe way to Fix the Problem: Advanced filter on a different sheet:

How to Fix Advanced filter on a different sheet with SmartPCFixer?

1. Click the button to download SmartPCFixer . Install it on your computer. Open it, and it will perform a scan for your computer. The junk files will be shown in the scan result.

2. After the scan is finished, you can see the errors and problems need to be repaired. Click Fix All.

3. The Repair part is finished, the speed of your computer will be much higher than before and the errors have been removed. You can also use other functions in SmartPCFixer. Like dll downloading, windows updating and print spooler error repair.