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
Solutions to the Problem Advanced filter on a different sheet
From the title of your question, i assume that you know how to use Advanced Filters in MS Excel. So try this
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
In cell C2 of sheet2, enter the specific region
Click on any other cell of sheet2 and go to Data > Sort and Filter > Advacned > Copy to another location
In the List range, select the source data range (first row is the header row) in sheet1; and
In the criteria range, select C1:C2 of sheet2
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.
,Troubleshoot:External Hard Drive not listed in Windows 7 backup wizard Error
,How to Fix Error - Getting an error "not connected to the internet" while trying to install Samsung Kies?
,How to Fix - Internet Explorer shuts down and reopens tab when attaching to email or uploading files.?
,Fast Solution to Problem: Sending Error Message
,[Anwsered] Thinkpad 8611 Boot,How to Resolve - Svchost Helper?,Fast Solution to Problem: L30 101 Driver Windows 7,Troubleshooter of Error: Io Device,How to Fix Error - Dell Laptop Code 39?
Read More: address of cell with maximum or minimum value in a range,adobe flash player will not load Tech Support,Troubleshoot:after install a new hard drive my 8 gb of memory only shows 4 gb Error,How Can You Fix - Add-ons became incompatible?,Fast Solution to Error: after installing 7 from vista computer ramdomly shut down like it lost power,a file called mDNSResponse.exe. is causing bonjour not to operate properly,what should I do?,A QUESTION USING THE "IF'S" Formula.,A continuos flashing window with which title is C:Windows\System32\cmd.exe, and has the following message: The syntax of the command is incorrect.,Acrobat compatibility issue and you tube problems____,ActiveX on IE 9 not loaded