Trevor, You are very good at teaching. Keep up the good work. I'm 79 and started on IBM mainframe using assembly in 1963. I'm truly amazed at what you can do with spreadsheets especially Excel and Google. I'm volunteering as treasurer for an organization and I'm having a blast amusing myself with Excel and hopefully provided a good service to the organization.
@ZafarWaheed
9 жыл бұрын
Mr. Trevor, I always have appreciated your excellent tutorials for excel, word and powerpoint. Thanks for your precious time and efforts. Your style of explanation is awesome.
@roxannesophia2979
8 жыл бұрын
Excellent tutorial. I spent more time trying to figure out the Excel "help" than it took to watch your tutorial and put it to immediate and successful use the same day I needed it. Well done!
@tubeyouJC88
8 жыл бұрын
This is great! Every time I can't figure something out on my user forms, I can always find it in one of your videos! Thanks for the videos Trevor
@OnLinePCLearning
8 жыл бұрын
Hi Jamie, Thanks for the feedback. Trev
@TSM-4444
4 жыл бұрын
Trevor, your videos have helped me time and time again! It seems you have a video on nearly everything I come across. As I am newish to VBA and teaching myself, your videos have been a tremendous help. Thanks for walking through the code so I understand why things work the way they do.
@renegade2610
2 жыл бұрын
Mr. Trevor, your tutorial very very useful for me (us) as a beginner in VBA. We try to apply to our work circumstances as an engineer for maintenance purpose by modifying range name etc. We are adding some column that indicating time limit and try to make it easy for any other user. How can we put column that will shown as color indicator. Example, cleaning job shall be done every six months, we want to get color change once the time closer to the next cleaning period (green to red), and make a button that can short the job based on that color. Appreciate your help
@bogdanudovicic391
8 жыл бұрын
Hi Trevor, I just wanted to say a big thanks and to tell you that you helped me a lot! Thanks!
@OnLinePCLearning
8 жыл бұрын
Hi Bogdan, Thanks for the feedback. I'm glad it helped. Trev
@petermire7564
3 жыл бұрын
Thanks very much Mr. Trevor. Your channel have changed my ability and I am very impressed. I am currently working on a project that will calculate test scores for students in grade school and I have encounters a problem in ranking data in with course and classes. I have a main dataBank that hold all the score in just one place from level three to eight, seven subjects and number of assessment. with the help of multiple criteria filtration I am able to get the to spacific data. but I am having problem ranking them because there are too much data of same name and samnumbers. Can you assist me??
@daveshortland9238
8 жыл бұрын
Hi Trevor, congrats on some fantastic videos/tutorials. I am having trouble with my advanced filter for some reason. My filter list has over 2000 rows of data, but when the filter populates (with all filter fields blank) only 476 rows copy over. It worked no problem with your template but when I did my own, this happened. The filter works, but all of the data isn't being used for some reason! Sorry for the long comment and keep up the awesomeness!!!
@rashmitaj
Жыл бұрын
I am facing same issue, clearing all filter criterion, all data is not picked up from data sheet. pls. share in case you are able to resolve it
@Takiki
6 жыл бұрын
Hi Sir! Thank you for this simple tutorial I would like to enter two possible values in an advanced filter criteria. For example : Criteria -> Price Value -> ="=20$ OR 30$". I have no clue how to write it correctly Thanks
@OnLinePCLearning
6 жыл бұрын
This tutorial may help www.onlinepclearning.com/vba-advanced-filter-and-or-operators/
@erickhaeussler5259
4 жыл бұрын
Just great! Subscribed and liked! Thank you very much for sharing this information. Greetings from Guatemala!
@JACandela
3 жыл бұрын
Hello! Thanks for the tutorial, even though it doesn't work perfectly for me, I have been able to do it with some changes. But now I would like to apply this to a UserForm with VBA, but I can't get it to work properly.
@KingofGames012
9 жыл бұрын
Great video. Your videos deserve more views and likes.
@Knych-nr4ot
7 жыл бұрын
Hi Mr. Trevor, please let me know where can I download the template. I am currently working on a sportsday program and this tutorial is really giving me great ideas, i just need some guidance on where to start.
@jagans9310
6 жыл бұрын
Awesome Video... I am trying this for last 2 month now I got..
@verajurevis8712
4 жыл бұрын
Great video. I'm looking for a way to copy over working hyperlinks when pasted after filter. Any additions needed to VBA? Thx.
@shijucherian007
5 жыл бұрын
Hello .. I must admit that this is a very descriptive and helpful video. I need some help with replicating the same logic to a data set I am working on. Like you explained, I followed the instructions to the "T" but still only one of the filter is working and it doesn't return any data when I use multiple criteria.
@user-qz6gz1bg1j
8 ай бұрын
Can you tell me if this template can still be accessed? The link provided on the video takes us to a broken webpage. Thank you for any assistance you can provide.
@muhammadsohaibarshad9652
4 жыл бұрын
Hi Mr Trevor, Really great work as usual. I am getting struck in criteria . Advance filter didn't gave results with asterisk (*) symbol present in the criteria range. When I remove Asterisk sign it works. Please help to make it perfectly work.
@danielpkd1
8 жыл бұрын
Hi Trevor, Excellent tutorial...A big thank you
@OnLinePCLearning
8 жыл бұрын
Hi Daniel, Thanks for the positive feedback. trev
@cv11710
7 жыл бұрын
Excellent tutorial... In my case I am looking to extract data (names) from a 7 columns (days in the Week, M thru Sun) that will give me the information of work performed from the names mentioned.. You think there is more convenience to use macro... and how can I do it...
@alanmckeown
4 жыл бұрын
hugely helpful - thank you for sharing your knowledge.
@mfarissolihin8644
4 жыл бұрын
Hi Trevor thanks you are a life saver How if I wanna print multiple criteria from one category? Let say I wanna print for Tax Category "medical" and "education"?
@lubegaish
6 жыл бұрын
Excellent tutorial. Only issue i found was that as soon as i click filterme it works as supposed to but the Dates filtered in C6 and D6 disappear.
@Edgaraza
9 жыл бұрын
Thank for your video... allways are helping me sharing your knowlage, Excellent video!!
@wayneseymour1
6 жыл бұрын
I have a column with numerical values I got nothing - blank. I copied and pasted your formulas exactly the same way you instructed to do =IF(E6="","*",E6). If I remove the formulas it wouldn't filter text seems to work fine but if numbers are in the search it doesn't work. In addition on some non-text columns ,with the formula in a column that has numbers it only returns one piece of data, although there are several rows of data present. r/emove the formula from the column with numbers everything works fine.
@ineedexcelhelpplease2344
8 жыл бұрын
Great video tutorial the only one I have found on KZitem to be relevant for what I require, keep it up! Following this tutorial I have experienced an issue, when I record the first Macro and select my Copy to Another Location, then select my data list range, then my criteria range with the formulas on, then my copy to location range and ensure all my heading are identical compared to my data range headings and then proceed with the advanced filter option, none of my data shows up under the range i selected for it to be copied to! I have tried so many times, made sure on so many occasions that all headings are identical and still no success, can i receive any help on this Thank You! :)
@deenikravings
6 жыл бұрын
Hi, Thanks for this awesome tutorial.. It is helping me a lot.. But can u please tell me if i am having one more date column and i want to filter data from that date also so which formula i can use because current using formula is not working in that case... Please help me out... Thanks
@marieellensigman6015
5 жыл бұрын
Hello Trevor - these videos are great. One problem, however, is if a cell in the data is blank, the row doesn't copy over with the filtered data. I have 4 criteria fields and i enter data into one of them. I know there are 3 rows of data that have that criteria, however, one of the cells (coincides with another criteria) is blank. So only two rows copy over to the paste area. How do i get the 3rd row with a blank cell to be included in the paste area?
@sahilaggarwal3130
4 жыл бұрын
Hello. I need urgent help. I did the exact same thing. my macro hides some data when you simply click "filter" when no criteria is selected and when the criteria block is not referenced to those other cells from where it is picking. However, when I do it manually, and type the criteria manually in the criteria block it shows all results. I really need. is it possible I can contact you somehow. I am not able to find any help on the internet. Plzzz. Your tutorials are great.
@Tro_unce
8 жыл бұрын
Excellent, well explained. Thank you very much...
@richarda5940
7 жыл бұрын
Hi Mr. Easton, the macro name typed is so tiny for my eyes, I can't see it even with my glasses on. it's really a great piece, thanks.
@RuiAlves1973
8 жыл бұрын
Hi Trevor, I'm glad to learn from your excellent tutorial. Congrats for excellent work! I'll try to apply this with my work. But before I need to ask... Does this work in Excel 2007?
@flackvanderdutch3081
10 ай бұрын
Superb ! Could you pls leave a gdrive link to download. Many thanks man !
@niktravel1820
3 жыл бұрын
Hi Trevor, how can i make filter show blank records ? For example: I have names in column A and surnames in colimn B (some surnames are blank cells) I want to Filter all names "John" (column A) AND all blank cells in column B.
@dt1045
4 жыл бұрын
This is great. Just what i need. However can anyone help me solve this.... If any number of cells in the Data table are blank or a number the whole row is not included in the search results. How can this be changed?
@kanavkohli794
3 жыл бұрын
Wildcards not working, maybe they updated that feature i dont have to put anything and it still works
@mejo6061
8 жыл бұрын
Hi Trevor,Thanks for this Video. I Did it. First few Moves work fine after I can't filter. Can You advice me what mistake I did.Thanks.
@mdsaiful6294
2 жыл бұрын
Nice video 😊
@lypperllc3673
5 жыл бұрын
Can you filter multiple criteria within one column, for example, within Tax Category list all Education & Medical? Thanks for a very practical turorial.
@gkhemer
3 жыл бұрын
Hi Mr. trevor, I'm a fan of your tutorial videos. I've tried to make my own from scratch following your instructions from here and from your website itself. I've already setup Dynamic name ranges, data validation, etc... Before clicking on Advanced Filter button, I selected the cell below the first column of the heading where we display the filtered result. However, in the Pop-up for the Advanced Filter it doesn't automatically select the whole area just like in your template but a pop-up error is displayed and it says: This command requires at least two rows of source data. You cannot use the command on a selection in only one row....So I tried selecting another cell within the area and it let me.. But, when I'm done with the setup, no filtered data has populated the target area.. As if nothing happens.. I really appreciate if you or anybody from here can give solution to this error. Badly needed to fix his for my project. Thanks
@boxsterman77
4 жыл бұрын
Maybe there is a difference in English language variants (British v. American) that I'm failing to appreciate, but when I hear BRACKET, I know it to be "[" or "]." What you continue to call a BRACKET is what I've ONLY heard many, many, many people--until now--refer to as parentheses. Around the world that's what they say. Why even at the Microsoft Campus in Redmond, WA, they, i.e., the people who developed the program Excel, refer to them as parenthesis. It's there in the onboard help and documentation. In fact, the only time I've heard them referred to otherwise is in ASCII or Unicode descriptions, where they are called both parenthesis and, less favorably, ROUND brackets--please do notice the adornment provided to the word bracket. The same code definitions clearly denote that, without that modifier, a bracket means exactly what I spelled out. This is not one of those things where differences will avoid nasty consequences like calling a trunk, a boot or an elevator a lift, or some cigarettes, fags---well, actually that latter one just may be problematic. But worse than accidentally employing a pejorative, if you are applying something into code, precision in language is vital. Why deliberately choose a word not widely known to describe the thing that you are trying to describe? These are parenthesis: "( )"; these are brackets: "[ ]"; these are braces (or sometimes 'curly' brackets: "{ }"; this is a caret ^ and these are guillemets: "«»".
@1973akader
7 жыл бұрын
Mr. Trevor as always your videos are an excellent source of knowledge and instructions. I applied all the concepts in your template to my worksheet and everything work but the dates. When I try to filter between two dates II got nothing even dough I have for example 99 records for the month of April if I enter the two dates 04/01/2016 & 04/30/2016 I got nothing - blank. I copied and pasted your formulas exactly the same way you instructed to do (=IF(D6="","
@mbayembengue6902
8 жыл бұрын
Hi Trevor ! You're doing great job Thank for all
@OnLinePCLearning
8 жыл бұрын
Much appreciated Trev
@kitmantsang7202
7 жыл бұрын
Got a quick question. Iam using 2007, the company single letter filter not really working, how can I get same result as 14:47? Only working with "Computer All" not working with a "c"
@harsukhhalai7660
3 жыл бұрын
Hi Trevor, in VBA Filter me macro - I am getting error message " Runtime Error 1004. AdvancedFilter method of Range class failed. Please can you advise. Thanks
@missmaiwinda4426
5 жыл бұрын
This is very cool, what if the receive date is changed to the time in hours?
@dstorm2007
4 жыл бұрын
Hi. I have over 3,000 rows of data. I tried using this filter but it barely goes over 150. I even tried clearing all the filters, and it cant even retrieve half of the data. Whats wrong??
@andreipocovnicu501
8 жыл бұрын
Thanks for the video. Very helpful. I downloaded the template and followed the steps. Once I got a grasp of how everything's done I started modifying the template for what I needed to do, I added more columns, added another name manager etc. Everything worked nicely. After that I added another userform button ('add details') in the data sheet. Also added another column and now I the function in the criteria does not work. When I try creating an advanced filter and press ok after I select everything it does not work. However, it copies the headings of where I want my data to go. If I delete the functions in the criteria and do the advanced filter, then it will copy my data. Can you please help?
@OnLinePCLearning
8 жыл бұрын
Hi Andrei, I'm happy to have a quick look at your file if you wish to contact me from the Support page on my website. Please supply the relevant information requested and I will send you an email. Please accept my best wishes Andrei truth
@GeorgeRon
7 жыл бұрын
I wonder how much time this code would take to filter through thousands of lines of data. The macro copies data into Filterdata line by line. For 200 lines of data, give or take 2 seconds on an 8gb RAM pc.
@ITSMRGRILLINI
3 жыл бұрын
Awesome tutorial, very easy to follow! I have a question, however. Is there a way to apply a similar operator that searches a string of text and displays it if the desired text is anywhere in the string? For example, in one cell I have multiple provinces (Ontario, Quebec) for example. If I search Quebec I get a false because Ontario is first. I’d like to be able to search either Ontario or Quebec and have the row appear in the filtered table. Any thoughts?
@ITSMRGRILLINI
3 жыл бұрын
For the nearly impossible chance that someone else needs it and finds this comment: =IF(E6=“”,”*”,"*"&E6&"*")
@tacticalsapper
8 жыл бұрын
I think it would be a pretty good idea to tell the viewers what Excel version you are using.
@col_180
5 жыл бұрын
Hi Trev, Great video that has worked an absolute charm for me. However I need just a little bit more: one of my data columns contains hyperlinks (added with the 'add hyperlink' right click button and not a cell formula as I only just discovered). These hyperlinks are not active on the filtered search sheet. How can I make sure the hyperlinks are active on the filtered search page? Thank you for your help! :)
@MohammedUsmanmus
9 жыл бұрын
Thank your very much Trevor Easton..i will try.
@ediesimon9878
8 жыл бұрын
Hello Trevor, I was able to get the advance filter to work however whenever I paste new data into the fields the advance filter only returns the title row. Any suggestions on how to fix this?
@garylillich
4 жыл бұрын
If I have 5 filters. How can I readily see all columns filtered? On my Excel, the down arrow is very small, hard to see.
@TezkaH
3 жыл бұрын
need help whenever i try to include wildcard the data doesnt show up but when i dont include the wild card when i try to set up the advance filter it shows up
@cindyhe8153
4 жыл бұрын
This one does not work from my end. I have to choose the criteria range from c5 to i5, then it works. May I know why. How can I fix this. Thank you
@prembaboo324
6 жыл бұрын
Sir, please make a video about sum between previous row and current row or sum total of all filter row using listbox in excel vba userform program
@munzollitower6341
9 жыл бұрын
Thank you I will make good use of it for sure.
@sivata95
4 жыл бұрын
thank you so much for the guidance..!
@titeo46
7 жыл бұрын
Hi, I'm facing some problems, my data are over 30mb, I need maps 3 different reports to have final decision, how to can link 3 workbooks and filter the information I need but I don't need to open 3 reports.
@georgemantafounis1393
6 жыл бұрын
i love it thank you from greece
@liviamachadogrebos6932
3 жыл бұрын
My filter is not working... I have checked all the formulas and the macro code seems also ok, can anyone please help me figure out what is wrong?
@medofat7968
4 жыл бұрын
thank you
@jagans9310
6 жыл бұрын
how can I delete filtered rows and remaining data should be in the list & I need to create delete box also, Please help me.. thanks in advance
@alexrosen8762
7 жыл бұрын
Great tutorial! Thank you Trevor :-)
@bhupendersingh6673
4 жыл бұрын
Hi sir I followed all step to record macro for advance filter but my filter only copy heading I did not miss any step please suggest why not working
@saeedtabirzadeh6717
8 жыл бұрын
hi thank you so much . can you please explain userforms too.
@erictsang789
6 жыл бұрын
Dear Tervor Good day, appreciated your work i tried but when i come to dynamic range sheet. I tried myself as below but fail. Is there a reasons/things that i missed ..Appreciated your help Sheets("Data").Range("A5:C42").AdvancedFilter Action:=xlFilterCopy, _ CriteriaRange:=Range("F2:H3"), CopyToRange:=Range("A7:C7"), Unique:=False Sheets2.range("a5").currentregion
@Dev_Bartwal
7 жыл бұрын
Amazing Easton Sir..
@womo7725
7 жыл бұрын
Moin Trevor, thanks for this tutorial!
@jasper8328
6 жыл бұрын
You are the best
@Takiki
6 жыл бұрын
How to use the wildcard "*" for columns that contain only numbers? If I use ="*" as a criteria for a column which contains only numbers, it does not match with any entry. Thank you
@OnLinePCLearning
6 жыл бұрын
Hi, I use ">1" for columns with numbers Trev
@pleidy333
7 жыл бұрын
Amazing, thank you!
@atsunnsarl501
7 жыл бұрын
its not works when we use digits format, its only works on text.
@Ct239Dzafirah
8 жыл бұрын
the formulas doesnt work on me even tho it is exactly the same. what could be the problem?
@OnLinePCLearning
8 жыл бұрын
What version of MS Office are you using?
@Ct239Dzafirah
8 жыл бұрын
+Trevor Easton 2013. when i use ur template, it is able to run smoothly. but after i removed and edit the headings, it cannt work. however, if i didnt put the formula, it works fine.
@ramadanibrahim4932
8 ай бұрын
Could you pls leave a google drive link to download
@ArashIrani
7 жыл бұрын
Hi Guys, I would like to know, how to filter each cell separately based on colour
@DevaP
7 жыл бұрын
How can use the same with data models in 2013?
@zo20002000
9 жыл бұрын
Hello Trevor I was also having issues with the filtering my data is about 1500 rows 9 columns wide
@OnLinePCLearning
9 жыл бұрын
zo20002000 Here is the link to the full tutorial. www.onlinepclearning.com/excel-advanced-filter-multiple-criteria/ It should be of help to you. Best wishes Trev
@zo20002000
9 жыл бұрын
Thanks for the link to full tutorial. I have experienced a few issues. 1 had ro break it up into sections to get it show data for certain fields. 2 It appears that some rows of data is missing any thoughts about this?
@OnLinePCLearning
9 жыл бұрын
zo20002000 Hi I can be contacted from the contact page of my website if you are using the template and working through the tutorial and are having problems Best wishes Trev
@neftalibautista5513
6 жыл бұрын
What if i just want to use wild cards without and leave date blank? Would it be possible?
@OnLinePCLearning
6 жыл бұрын
Hi, Absolutely add them with the formula between the "*"
@juandisiregar
6 жыл бұрын
It is amazing tutorial, but i can not running row source "FilterData" in ListData form, it sound " could not set the RowSource property. Invalid property value". I am using Excel 2013. Please help me... Thank you.
@OnLinePCLearning
6 жыл бұрын
Juandi Siregar Hi Check the named range is working before you add it to the rowcource. You can check it in the Name Manager on the ribbon. Trev
@OnLinePCLearning
6 жыл бұрын
Hi Check that the named range is working. Check it in the name Manager. Trev
@juandisiregar
6 жыл бұрын
Trevor E Sir, i already check it and it is not running the selected area like the others... How could i fixed it...? And i am confusing about number "9" in the last of "FilterData" formula... Thank you Sir...
@OnLinePCLearning
6 жыл бұрын
9 will be the number of columns to offset. You will need to have the named range working before u proceed. Trev
@OnLinePCLearning
6 жыл бұрын
9 will be the number of columns to offset. Trev
@usmaniqbal1836
2 жыл бұрын
please share link to download file for practice
@lorikuklinski5195
7 жыл бұрын
Why do my headers transfer to my new page but not the data? Instead of a blank cell, I have the word "SELECT" in my dropdown list. My formulas look liker this: =IF(G4="SELECT","*",G4). I've used your spreadsheet to see if blank cells and rows had an effect, but as long as the headers were not blank, it worked fine. Help! I swear I've tried everything.
@OnLinePCLearning
7 жыл бұрын
Hi Lori, Select is a reserved Excel keyword it should not be used.I am not sure what exactly you are trying to do but a good tip is to run the filter manually from the ribbon. This is a good way to pick up errors in advanced filters. Trev
@lorikuklinski5195
7 жыл бұрын
Hi Trevor, Thanks for the response. I appreciate it! I will go back and correct this and see what happens. However, in the interim, I did stumble upon this: When I removed the headers from my criteria range, ALL of the data is now being pulled into my filter sheet, no matter what I try to filter. I wonder if the "*" part of my formula is causing this. I want a filter that pulls anything that was selected, and ignores anything that isn't.
@lorikuklinski5195
7 жыл бұрын
I removed the "SELECT" from my dropdown lists; the problem remains. It pulls in all the data from within the criteria range and not just the selected data.
@OnLinePCLearning
7 жыл бұрын
Hi Lori, Make sure all headers are spelt the same in the 3 locations. Use * for text columns and >1 for numbers. Run it from the ribbon until u find your error. Trev
@lorikuklinski5195
7 жыл бұрын
By ribbon, I assume you that mean the normal filter, and yes, it works fine there but not with Advanced Filters and yes, all labels are exactly named. However, I did set up my form differently, prior to my attempting to use Advanced Filters. My pull down headers lie in 3 columns and approx 8 rows down. Still, the data pulls into the filtered range; it just doesn't filter. I suspect it has to do with placement of my dropsowns but that doesn't quite make sense either.
@mohamedhasanbasari
6 жыл бұрын
Working Good - Date criteria only not working
@mohamedhasanbasari
6 жыл бұрын
Great Videos it is working . but not work on table
@OnLinePCLearning
6 жыл бұрын
That is correct. Advanced filters work on ranges not tables. Convert the table to a range.
@mohamedhasanbasari
6 жыл бұрын
Trevor Easton thank you for your reply...convert to ranges face some problem..when. Record the vba after open the code totally different..
@erikpischner3539
Жыл бұрын
Unfortunately his site is down
@alexrosen8762
7 жыл бұрын
Can't find the follow up video though :-(
@MohammedUsmanmus
9 жыл бұрын
Thanks for your video... My Query: I have a database of around 50,000 thousand Rows with 14 Columns, i tried to use this database with your advance filter but its not working, may is not suit/work for bigger database. please answer. Thanks
@OnLinePCLearning
9 жыл бұрын
Mohammed Usman Hi Mohammed, Create a test file with a small amount of data and start with a couple of criteria for the filter. This test should answer your question as to wether your problem is data size or structure. I have used this with large data sets. Best wishes Trev
@syamsurrijal4968
6 жыл бұрын
can you upload the example file?
@ifteqaruddinmohd3104
8 жыл бұрын
its not working properly plz hlp.... by posting another video
@hrmnpsrffn
Жыл бұрын
Website is inaccessible. 😔
@AnwarAlfaqeehAlhusseini
4 жыл бұрын
not work with me the ctiteria
@razormk2611
7 жыл бұрын
It is not working even if i follow the correct steps already. Please help me
@OnLinePCLearning
7 жыл бұрын
There is a request support page on he website.
@razormk2611
7 жыл бұрын
Thank you. I'm doing the request support page right now. Will I send you a copy of my project?
@razormk2611
7 жыл бұрын
I have successfully sent the help/support request sir. I hope you would be able to receive it. I've indicated every detail you've asked. If you would need the project that I'm having trouble with, I may send you the file. Thank you sir.
@vindaferdhiani
7 жыл бұрын
Hello I want to ask something. Why can't I use this function..(counta)? Please reply my question. Thankyou :)
@mountagadiallo6433
6 жыл бұрын
Where is the next tutorial ???
@OnLinePCLearning
6 жыл бұрын
Hi, Here is the link. www.onlinepclearning.com/advanced-filters-in-userforms/
@ifteqaruddinmohd3104
8 жыл бұрын
its not plz hlp....
@eyyubismayilzade3030
6 жыл бұрын
yaqub
@diegoqvaljean4055
5 жыл бұрын
Good info but way way to long. Get to the point! but thx
Пікірлер: 140