Filter Excel Data to a Different Sheet
Articles Blog

Filter Excel Data to a Different Sheet


In Excel you can use an advanced filter if
you want to take data out of a list and put it into a different place your workbook In this example we have a list of orders
and we’d like to pull the top orders out of the list so our criteria here has the same
heading — Total — as we have in the main table and we put in the criteria of greater than
fifteen hundred so only the orders that are greater than that amount will be pulled out of this table We would like the data to end up
on a different worksheet so here’s our order sheet and we would like to
pull the information onto the Top Orders sheet We only want the date and customer from that
table so those are the only headings i’ve put here which is where we’ll extract the data if we want to pull data using an advanced filter and have it end up
on a different sheet we have to start the advanced filter on that destination sheet so we’re on the Top Order sheet and i’m going
to select a cell that’s away from those headings so just a blank cell down here and then I’ll go to the Data menu and click on Filter and click Advanced Filter We want to copy to another location and and i’m going to select the List Range
so I’ll go back to the order sheet and just select the entire table The criteria range I’ll go back to Orders and just select those two cells and for Copy To I want to use these two headings on the Top Order sheet I’ll click OK and you can see the three orders that we had that were over fifteen hundred dollars

23 thoughts on “Filter Excel Data to a Different Sheet

  1. @Rodmusic2000 Thanks, I'm glad the video helped you. To make the list update automatically, you'd need to create a macro to run the filter when a change is made in the criteria range. There's a sample on the Contextures website (click link in video description). On the Sample Files page, under Filters, look for FL0002 – Product List by Week Number.

  2. Super Vedio Thankl you for Psoting I love excel and techinq how she explained. Expecting more Techniqs, Please upload.

  3. Excellent, thanks This is very close to what I need.
    Can you help me ? I need a macro that will verify the past due for more than 190 days and the values need to move to another worksheet. I guess it's need to be done with a macro. I appreciate your advanced help.

  4. It is an amazing job- but I could not get the 3 on the top orders- also the date such as
    01/010/2009 alwasy comes out different one-and it does not show in the sample.
    Also when trying to put the the prices in- can't get it right- could you please explain-thanks

  5. do you know how to sort something related to time? I would like to sort information with an hourly increment instead of a 5 minute incremement, so i would like to have my data showing 12:00, 13:00, 14:00 and so on for a few months worth of data. I'm not sure however, how to state in my cell that I am looking for hourly information. Thank you.

  6. Thanks for this great video, but can the list update if you change the criteria? Like for example, if I decided I want to show results for <1200, I would like to be able to change the criteria and have the returned results reflect that change.

  7. Thanks. Your videos are great, but I added a increase/decrease buttons to change the ´Criteria Range´ cell linked to a "VLOOOKUP" formula and doesn´t update the Results until I press the Enter key…I will apreciate your help…Thanks in advance 🙂

  8. thank you! it took me two hours to manually sort my data, then found an error. didn't want to go through that ordeal again – found your video, and the sort now took 2 minutes.

  9. Just Copy and Paste as link, whatever you wanna transpose or transfer. It will update automatically whenever you change values in the original worksheet.

  10. You said copy ad past as link. what does that mean, im struggling to auto update values to the new sheet, when i add to the master data sheet

Leave a Reply

Your email address will not be published. Required fields are marked *

Back To Top