VBA to Copy and Paste Filtered data

This Excel VBA Tutorial explains, how to copy and paste filtered data and filtered rows.

[@MohAboAbdo]

Thank you very much for this great video.
Thank You So Mutch, Sir.

[@ExcelDestination]

You are most welcome

[@shaileshmishra5107]

What code u use for creating all the filter value and pate in to multiple sheets

[@sprittube7237]

Thanks ... Very nicely explained......👍👍

[@ExcelDestination]

Most welcome 😊

[@akashdeepchaursia]

Very useful

[@pavankulkarni1326]

Thank you, Indeed it's fantastic code

[@ExcelDestination]

Welcome

[@sachinshinde5997]

very helpful...Thank you.....

[@ExcelDestination]

Glad it was helpful!

[@abhishekshirsekar2065]

Hi sir thanks a lot for ur brief explanation on filter data copy n paste we expecting more data on conplicated code on vba

[@ExcelDestination]

Will upload soon

[@suralasika]

I am new to Vba. I need a small help. I have data with a chart.. So how can I copy the table along with the chart based on the filter values.

[@lilyfullery4779]

Hi thanks for the video ‘ while doing the same its throwing error cause the given critera not present in field ‘ please give the solution

[@budikwkw3910]

Good video...
Bikin tutor lagi gan...
Proses sama seperti video ini,,,,
Cuman yang membedakan filternya melalui userform...
Kriteri ComboBox...
🙏🙏🙏

[@sindarl01]

Thankyou my friend.

[@ExcelDestination]

welcome

[@jeffreyghb]

Great video. What if I want to cut and paste instead? I tried changing Selection.Copy to Selection.Cut but didn't work

[@ExcelDestination]

you can try Range("give range").Cut instead of Selection.Cut

[@kannannable]

Hi Sir, Nice Video. What if I want to copy all the values one by one using the filter to other sheets? Instead of putting Criteria:="HDFC", I need to copy all the values in another sheet. Could you please help me with that?

[@ExcelDestination]

you can modify this code. if you want us to work on your work, please share your project requirement at [e-mail]

[@mavalswadh]

hello !!
this code is good but if i want to copy a filtered data say HDFC and paste it in HDFC worksheet and CANARA and paste it in CANARA WORKSHEET like these multiple criteria in different workshetts not in one

[@ayushbagmar6478]

Hi, video is very helpful. Question: What change do we have to do if we want to filter and paste multiple fields to another sheet. Also the data of master sheets gets refreshed each day, so how can we make the macro dynamic.
Thanks, could not locate your email id.

[@hoangsonuongbui5985]

Please help me with a Vba code that take data from one sheet, filtered each company name and apply it to multiple sheet

[@ExcelDestination]

for any excel vba macro project, you can send email to [e-mail]

[@jundidoang7346]

Very good tutorial. Please attach the excample excel file

[@ExcelDestination]

Thank you, I will

[@InsideMyWall]

I want to create a button to delete all the filtered copied data once I am done with the data.

[@manioommen871]

Good video.
Wouldn't it be more simple if we use macro recording at first and edit the code?

[@ExcelDestination]

Depends

[@abhishekshirsekar2065]

Sir can u make vba video on selecting grand total of pivot and colour the same and coloure sheet name and protect formula we are expecting the same thanks a lot once again

[@ExcelDestination]

Will try

[@saraswatinegi8076]

Agar data bar bar filter kr ke sheet 2 me ek ke bad ek add krna ho to kese krenge. Ye to one time ke liye hi hoga na.

[@ExcelDestination]

you can use looping statement

[@saraswatinegi8076]

@@ExcelDestination how

[@AbhishekSingh-du5di]

You forgot to cover multiple criteria on multiple fields at once!

[@ExcelDestination]

ok. let me create a new tutorial for that.

[@jodysidney9761]

@@ExcelDestination hey did you make the one with multiple criteria yet?

[@shaileshmishra5107]

What code u use for creating all the filter value and pate in to multiple sheets

[@ExcelDestination]

let me create a tutorial for pasting to multiple sheets.