Excel: Copy Filtered Data to Another Worksheet Automatically

Excel: Copy Filtered Data to Another Worksheet Automatically | Advanced Filter (With VBA) & FILTER

Рет қаралды 101,359

Күн бұрын

Download the featured file here (including VBA code): www.bluepecantraining.com/exc...
In this Microsoft Excel video tutorial I demonstrate how to copy filtered data to another worksheet automatically. I explore two methods.
METHOD 1: Use the Advanced Filter with VBA
The advanced filter allows you to copy filtered results to another worksheet but it doesn't update automatically if you change your data or criteria. You can however add VBA code to the filter which will update it automatically.
METHOD 2: Use the FILTER Function (Excel 365)
If you have Excel 365, you can use the FILTER function to copy filtered data to another worksheet. This method does not require any VBA and will update automatically when the data or criteria is changed.
Table of Contents:
00:00 - Introduction
00:15 - Using the Advanced Filter
02:04 - Auto Update the Advanced Filter with VBA
04:14 - Using the FILTER function
------------------------

Пікірлер: 25

@IvanCortinas_ES Жыл бұрын

A big advantage is to use CurrentRegion inside the macro. Thank you Chester.

@rakastettu2 5 ай бұрын

Used this successfully in Google Sheets and has saved me so much time. Thank you so much!

@shaunrowley7230 Жыл бұрын

Excellent and helped me understand the filter function in Excel 365

@emilytran84 6 ай бұрын

Thank you for your video. Easy understanding and helpful !

@cristinagaldona951 9 ай бұрын

What a helpful video! Thank you for posting

@zouagrimohammed Жыл бұрын

Thanks so much for this good and simple tutorial 🎉🎉🎉🎉

@LordBransty Жыл бұрын

Great stuff. Thank you!

@teoxengineer Жыл бұрын

Thank you. It is amazing by using advance filter with vba. However, you didn’t mention about when we would want to use or criteria with advanced filter. How can we return multiple criteria with advance filter?

@sarthakc5224 Жыл бұрын

Thank you sir !

@Obrik Жыл бұрын

Thank you much ^^

@peterhosking2705 Ай бұрын

Nice work, thank you

@alializadeh8195 Жыл бұрын

Thanks

@hojatzahedi7794 Ай бұрын

Thanks a lot

@paulinetluong 11 ай бұрын

Thank you for this helpful tutorial. I was able to create the filtered table on the other sheet, but when I went to "View Code" to make the Advanced Filter update every time, there was no written code that shows up in VBA. Could you help me here?

@georgegucchi3680 7 ай бұрын

Wow! Thank you. I had been trying to use the Filter formula and it just keep blowing up trying to filter an array.

@user-zx5gk7kk5s 2 ай бұрын

Excellent video. I have been searching for a video like this for a long time. Thank you. I do have a question. I followed your instructions all the way, but in my case, I'm trying to use this formula to transfer certain transactions from my check register to add to my savings registry. This formula allowed me to transfer the amount, but it will show up as a deduction only. I need it to show up in the credit or deposit column. Any suggestions?

@edcooper1471 4 ай бұрын

What if I add (insert) a new row of data, in the middle of the worksheet data, or the beginning or the end the worksheet data? Will it autmatically adjust to accommodate the new range?

@laurengreen6281 4 ай бұрын

How would I apply this filter formula to a whole sheet? And the function doesnt seem to work if there are blank cells too. Any ideas?

@racheljones7045 6 ай бұрын

Is there a way to do this same thing in google sheets?

@zouagrimohammed Жыл бұрын

Thanks but i rewrite the text code, because i have the Microsoft office pro plis 2016

@chintanprajapati5898 Жыл бұрын

One excel multiple sheet (10 sheet).. In all sheets Multiple city data (15 city) If any short way to split - In one excel 10 sheet with 1 city wise data split.

@MrDelivered911 10 ай бұрын

I typed this exactly as shown except with items relevant to my data. I keep getting “compile error: expected list separator or )”. What am i doing wrong

@MrDelivered911 10 ай бұрын

It highlights the (“A1”)

@user99744 2 ай бұрын

Got same error...got an idea how to resolve it?