Bringing all these together was like a magic pill. so awesome... I'm glad I found your course. thank you so much for this wonderful tutorial
@TigerSpreadsheetSolutions
Ай бұрын
It's a pleasure my friend - we have many more series like this on the channel. See you in the next one and good luck!
@kurtturner5120
4 жыл бұрын
Awesome teaching skills. Not many instructors get into the detail behind the code for people seeing it for the first time. Thanks for taking the extra time to be very detailed. We all appreciate all of the hard work that goes into your videos. As a beginner, I find this very helpful and will continue to follow all of your classes. Cheers!
@TigerSpreadsheetSolutions
4 жыл бұрын
Thank you so much, Kurt! Do check out the other videos on the channel.
@johnmazzella9198
6 жыл бұрын
I watched all of your beginner's videos and I now have a better understanding of what VBD code does. Thank you for taking the time to make these videos and the way you presented the information, you my sir are an excellent teacher! Greetings from Texas, USA
@TigerSpreadsheetSolutions
6 жыл бұрын
Hi John - good to hear the videos are helping. Please do share the videos with somebody else whom they might help. Good luck!
@TonyK55
7 жыл бұрын
I am not a VBA coder but I am now confident that I can start to use VBA in my spreadsheet work in order to stretch my Excel expertise further. Thank you On your style of teaching and presentation I thought you put a personal touch to the explanations, something that is missing from most references I have seen so far, well done!
@TigerSpreadsheetSolutions
7 жыл бұрын
Really good to hear Tony! Please spread the word about the Tiger channel, and good luck with your coding - plenty more coding videos to work through on the channel, and plenty more to come this year.
@peternganga9371
3 жыл бұрын
"Coding made easy" to me again; like teaching sounds recognition and reading phrases to a kidergatten beginer in a day. Excellent work. Keep it up #ExcelRevolution and Tiger Spreadsheet Solutions.
@TigerSpreadsheetSolutions
3 жыл бұрын
Really appreciate the comments! Thanks.
@krg1605
2 жыл бұрын
Love these videos! Have read several publications to learn VBA and none of them explains the topic as clearly as this. One thing - I noticed that the code for creating each report actually creates them in reverse order. So I had a bit of an experiment and edited this line to create them in number order.......... and it worked a treat! Sheets("Test").Copy After:=Sheets(Sheets.Count) 'copy the sheet
@TigerSpreadsheetSolutions
2 жыл бұрын
Thank you - and that's a great addition to the code
@m0209
3 жыл бұрын
very valuable information, and I appreciate the pace at which you explain the material. thank you!
@TigerSpreadsheetSolutions
3 жыл бұрын
You're very welcome - do check out the other video series
@m0209
3 жыл бұрын
@@TigerSpreadsheetSolutions You literally saved me hours and hours by pointing out the OffSet command :) My current tasks has been to take a massive spreadsheet (over 300 columns) and parse it 7 or 8 columns at a time to allow a legacy program to load it, but in separate CSV files. The series of your videos launched me into creating the programs needed. I am re-watching your post Beginner videos and they all have a wealth of information
@stevenlagoe7808
3 жыл бұрын
I taught myself BASIC programming way back in the 80s on a Sinclair ZX-81. I found it great fun but didn't think it would have any value in the real world outside my home computer. Many years later at work I was introduced to Excel. I thought, 'Wow! What an interesting program!' Then one day one of my colleagues just happened to mention that you could program Excel using VBA. I had no idea what VBA was until he showed me some of his macro code. Talk about a Eureka! moment. I remember shouting, 'VBA? That's just BASIC with a facelift!' Since that moment I've been coding VBA in Excel ever since, both at work and for my own enjoyment. I've largely taught myself Excel as well, so obviously after all these years I know a lot, but I'm the first to admit I don't know everything, so I thought I'd watch your videos to see how I should be doing it. I have to say, you're an excellent teacher. Your presentation is very clear and your enthusiasm for Excel is obvious. It makes such a difference when the teacher loves their subject, rather than just reading from a script. I've learned some new tricks and techniques! For instance, in the example in your video, I would have used CELLS(row,column) to move around the data, but OFFSET is much more professional. Up until now I've only used OFFSET in WorkSheet formulae, but I'm going to bare it in mind for my future projects - one of which is Excel Chess! (Talk about a sucker for punishment!)
@TigerSpreadsheetSolutions
3 жыл бұрын
Hi Steven - great to hear your story and welcome! I actually favour .Cells myself these days, but it's great to have both methods in your toolkit. Good luck!
@runwiththerunners8152
3 жыл бұрын
I have spent the whole day, 1st your VBA Foundation, then these 6 lessons. They are brilliant. I will see what other VBA courses you do I can follow through on. The instruction is first class thank you so much.
@TigerSpreadsheetSolutions
3 жыл бұрын
It's a pleasure and welcome
@aliciakiansmum905
7 жыл бұрын
Really useful introduction to VBA, being a complete novice I need this kind of baby steps approach.
@eberkamuti1862
5 жыл бұрын
i like your technique of testing piece by piece and naming each line. there are so many coder i cannot follow because they don't code each line and what it's for. it makes it so easy to follow.
@TigerSpreadsheetSolutions
5 жыл бұрын
Good to hear Everly. Yes, 'stepping into' (F8 key on the PC) the code is absolutely crucial to understanding it. Please spread the word about the videos!
@walle2024
5 жыл бұрын
Thank you for taking the time and creating the training videos. I was always scared of programming. You made it look easy and for the first time in 33 years of life, I feel like I can learn programming. Great videos.
@TigerSpreadsheetSolutions
5 жыл бұрын
Hi there - I am very happy you feel this way about the videos. I too accessed programming later in life, you can still make great progress, very quickly. Good luck!
@safajamal5748
7 жыл бұрын
This series of videos are very helpful. I liked how you present your thinking process loudly, you made me see how the VB process the commands. I wish you could introduce more videos on VB like intermediate and advanced. Thanks again.
@TigerSpreadsheetSolutions
7 жыл бұрын
Thank you Safa - there are many more VBA videos on the channel, enjoy!
@venkatramana3258
8 жыл бұрын
Excellent teaching skills, thought from basic, and shown how to use all those small basics to write a complex code, first time I ever felt writing macro is so easy, thanks a lot for all the videos published, and anticipate more down the line. All the best.
@TigerSpreadsheetSolutions
8 жыл бұрын
+Venkat Ramana Many thanks Venkat - more videos to come this year, good luck!
@sandeeppeddi7075
5 жыл бұрын
Short and sweet I actually have no idea what VBA is, by watching some vedios by my routine channels of interest I lost my confidence that I can learn this course. They just showed it as too complicated. But luckily I found this and it created interest in the course. Thank you for amazing vedio !!!
@TigerSpreadsheetSolutions
5 жыл бұрын
Sandeep - very happy you found us and the that videos are helping :-)
@wasimbader9170
8 жыл бұрын
NOW THAT WAS SO VERY WELL TAUGHT AND I UNDERSTOOD ALL OF THE CODES. I HOPE YOU WILL DO WITH SOLVER, FORECASTING, BUSINESS ANALYSIS AND ORDERING WITH TRACKING. ONE MORE THING I AM LOOKING FOR SOMEONE TO TEACH ME SQL, SAS, WITH EXCEL PLUS VBA TO GO FOR DATA ANALYST. TILL NOW I HAVE NOT FOUND THE RIGHT PLACE WHO CARRY OUT ALL THESE WITH CERTIFICATION. ANYWAY WITH THE HELP OF YOU TUBE, I AM DOING COURSES SO NOT TO WASTE TIME IN LOOKING AND I AM SURE ALL THESE VIDEOS WILL MAKE ME PROUD. THUMBS UP AGAIN
@TigerSpreadsheetSolutions
8 жыл бұрын
+Wasim Bader Thanks Wasim, glad to hear that it helped. Good luck with your studies.
@haleshtalawar3656
6 жыл бұрын
you tube has to provide multiple thumbs up option so that i can give 100 of thumbs to this sir.After seeing your video, I started loving VBA. Great work sir.
@TigerSpreadsheetSolutions
6 жыл бұрын
100 Thank Yous, Halesh! The most important thing is that you now enjoy VBA. If you can enjoy it and feel a sense of 'play' when you are coding, the sky is the limit. Good luck.
@userme2803
3 жыл бұрын
Excellent video. Thank you. Can you make more video like that showing or resolving real-life problems/scenarios. Thanks again.
@TigerSpreadsheetSolutions
3 жыл бұрын
Thank you - you can find plenty of videos like this on the channel, enjoy!
@alisond7395
8 жыл бұрын
Brilliantly explained video. Watched them a few times as I'm new to VBA and understanding the basics is heavy going. Thanks for an excellent series.
@johnl9408
5 жыл бұрын
I have always wanted to learn some coding. Thanks for the videos, I will be going thru them all. Great instructor.
@TigerSpreadsheetSolutions
5 жыл бұрын
Great to have you on the channel John, good luck!
@pingyan80
5 жыл бұрын
Just want to say Thank You! Have gone through the basic and advanced tutorial. They are really helpful!
@TigerSpreadsheetSolutions
5 жыл бұрын
You're welcome - please do share the videos with somebody else whom they might help :-)
@maguedsedra
6 жыл бұрын
you are just great. very competent and professional, know how to explain well the things, good video/audio quality. nothing compared to other videos out there. thank you!
@TigerSpreadsheetSolutions
6 жыл бұрын
Hi there - thanks for the kind comment. Please do spread the word about the channel :-)
@hansvanleeuwen9524
8 жыл бұрын
Excellent Video training! Your presentation is very clear and easy to understand (even for a Dutchman like me and the topics treaded seems very valuable and practical to me. Many thanks!
@TigerSpreadsheetSolutions
8 жыл бұрын
+Hans van Leeuwen You're welcome Hans - good luck with the coding!
@rhymiekollie5190
7 жыл бұрын
hi
@ankitshah6591
7 жыл бұрын
sir, this is the first video I watched of you and I like your teaching style very good. Thank you sir
@TigerSpreadsheetSolutions
7 жыл бұрын
Thank you Ankit - there are plenty more for you to watch, good luck!
@GoldenShorts871
6 жыл бұрын
Hello Mr. Tiger, Thank you very very much for your amazing excel vba tutorials. I just wanted one more session on how to connect to database ( Oracle database) using macro code and also how to perform manipulations( select, insert, update,delete) Thanks in advance
@user-pf4rx4rd8y
5 жыл бұрын
Your videos are amazing. Simple and effective. Love how you explain the "why", the most important thing about learning. Helping me advance my ability immensely. Thank You!
@TigerSpreadsheetSolutions
5 жыл бұрын
Robby - thank you and great to have you on the channel. I'm glad you appreciate the 'why' explanations - hopefully they give context and motivation to the techniques. Good work!
@jamesbarnett5236
5 жыл бұрын
Great videos!!! Thanks for creating this channel and posting these videos. I’ve only watched the first 10 or so thus far but I plan to keep watching and practicing so that I can develop my VBA skills to an adequate level.
@TigerSpreadsheetSolutions
5 жыл бұрын
James, great to hear - practice is key, so keep it up!
@carolliu5713
5 жыл бұрын
Very helpful after I attended a two days face to face training
@TigerSpreadsheetSolutions
5 жыл бұрын
Happy it helped :-)
@rayhitchcock4899
7 жыл бұрын
Excellent set of Tutorials which I have just worked through as you suggested. I used to program a little using BBC Basic in the 1980's but nothing since... this is fun! Your explanations are first class, all I have to do now is remember the various syntax! I am interested in working towards building a database for club membership (200 members) which I currently hold on MS Access. Problem is that successive incumbents might not have the MS Access software but are much more likely to have Excel. Using "buttons" to activate custom routines for extracting selected data could make it very easy to learn the task... in any case, it will be fun trying to construct such a system. But first I will explore more of your Tutorials, thanks for taking the time to create them.
@TigerSpreadsheetSolutions
7 жыл бұрын
Good to hear Ray, and I totally agree, it can be 'fun', if you can adopt the right mindset! I hope at least some of the skills you learned in BBC Basic (on an Acorn maybe) are transferable :-) Very happy to have you on the channel.
@ethanwood9598
Жыл бұрын
Only change I would do is to make the code dynamic by using a while statement until it reaches an empty cell. This stops the code from breaking if anything else is added in the sheet and can serve as a way to introduce while loops to the audience
@TigerSpreadsheetSolutions
Жыл бұрын
Good idea Ethan - it would be nice addition to this classic series!
@ericgottlieb8275
7 жыл бұрын
I am already using VBA at work! Today I ran a cool loop within a loop to do a mindless task I would have had to do manually
@TigerSpreadsheetSolutions
7 жыл бұрын
Great to hear Eric, keep it up!
@psclhys
7 жыл бұрын
I can't add much substance that has not been stated previously by other commenters. I can say this is the most effective VBA learning tool I've ever seen. I use basic run of the mill spreadsheet stuff in my engineering office everyday and everyday I kick myself for not learning more about automated tasks. Your brilliant presentation with the side by side VBA and excel sheets and your revealing thought processes have at long last got me off the dime. Many many thanks to you for posting. Where do I send the check?
@TigerSpreadsheetSolutions
7 жыл бұрын
Many thanks Pascal! The whole purpose of the videos is to open people's eyes to the impact computer programming can have on day-to-day work. Great to hear you've felt the impact of the techniques. Keep it up!
@lillianasanchez5984
5 жыл бұрын
Fantastic tutorial, really good communication skills and transfer of knowledge, I followed the exercises and made my own homework, in fact I am looking to learn more and advance more in this, thank you so much for making these videos.
@TigerSpreadsheetSolutions
5 жыл бұрын
Lilliana - good to hear about your progress. Please do tell somebody else whom the videos might help about the channel.
@powerstar817
7 жыл бұрын
This is a very best place to start and finish vba and I really like the way of teaching its really awesome !!!!!
@TigerSpreadsheetSolutions
7 жыл бұрын
Thanks Vijay! Please do spread the word about the Tiger channel...
@powerstar817
7 жыл бұрын
ill do it definitely!!
@lizo4845
8 жыл бұрын
Thanks for the tutorial. Very helpful with what I’m working on. For my tutoring agency, I’m currently trying to build a user form that inserts, edits, saves…student and tutors personal and tuition details, before exporting in to separate student, Tutors, Lessons and Payment tables. A few variables will have to be derived such as Age of student, Number of Students/Tutors and Total payment. It may be good material for a video series.
@hi2832
3 жыл бұрын
Very well presented. I wish I could have found this few years back.
@TigerSpreadsheetSolutions
3 жыл бұрын
Great to hear Raheel and welcome
@aaswijesekara5272
5 жыл бұрын
i watched the full series,excellent explanations . i hope you can do series with access .Thank you , i'm from Srilanka.
@TigerSpreadsheetSolutions
5 жыл бұрын
Many thanks. It's Excel only for the timebeing I am afraid. Good luck with your coding!
@joemorris1282
5 жыл бұрын
That seems to be working well... Honestly thank you so much for this, your video series has taught me a lot and will save me so much time in the future! Thanks!
@TigerSpreadsheetSolutions
5 жыл бұрын
Many thanks Joseph and good luck with your coding!
@joseluisvelarde8051
2 жыл бұрын
I would be interested in a loop where one guesses at a number, the spread sheet calculates a number, and if the difference between the guessed number and the calculated number is less than o.1, the loop stops. Your lectures were very good. Thank you very much.
@TigerSpreadsheetSolutions
2 жыл бұрын
Jose - nice, creative idea. It's all possible with VBA. In the Excel VBA Building Blocks course on the website (free), there's a walkthrough video of me building a VBA application similar to this - do check that out.
@DarknessChampion
8 жыл бұрын
Amazing tutorial series!! Thank you for sharing your knowledge in a clear and professional way! Really looking forward to more videos with more techniques whether they are beginner, intermediate, or advanced!! SUBSCRIBED.
@johnpetersay2421
5 жыл бұрын
Awesome series of videos. I hope to learn more from your channel. Thanks! John from Sri Lanka
@TigerSpreadsheetSolutions
5 жыл бұрын
Many thanks John, good to have you on the channel!
@rickolin
6 жыл бұрын
Your tutorials are amazing!! I'm slowly picking everything up and you do a great job of explaining it all to make sense. Looking forward to learning more :)
@TigerSpreadsheetSolutions
6 жыл бұрын
Cheers Nick - very happy to have you on the channel
@mudit21bareja
8 жыл бұрын
Great work!! Thank you so much. Again very simple, clear and crisp explanations :) Looking good too!! Keep up the good work and wish you all the success!!
@serhiiminin5132
5 жыл бұрын
Thanks a lot for your videos. The 10 videos of yours are way more productive then some 10+ hours courses where they explaine 30 minutes very simple things. Will you do more of your tutorials? Would be interesting to see intermediate and andvanced levels. Thanks!
@TigerSpreadsheetSolutions
5 жыл бұрын
Hi there - thank you! There are many more advanced applications on the channel, I recommend our 'VBA for Beginners' playlist. Enjoy the content.
@metalpower18
5 жыл бұрын
Thank you sir for those videos, I am used to coding but honestly I don't like VBA syntax and I was shunning it but thanks to you I started getting into to :p
@TigerSpreadsheetSolutions
5 жыл бұрын
Hi there - great to hear you have started learning VBA! Plenty more videos on the channel, good luck.
@alexandrumarcel3696
5 жыл бұрын
Currently I'm working on a macro which needs to open 124 csv files, filter the data on many levels(5 or 6), then open another excels file that contain labels of the currently 124 csv's files(those ones contain only codes, without labels), then execute a vlookup for some specific columns picked by user, then append all these csv files into one final database (which exceed 1.5 million rows) :D
@TigerSpreadsheetSolutions
5 жыл бұрын
Alexandru - sounds like a good challenge. I can see you have conceptualised the task clearly in your own head, which is the most difficult part, let me know how it goes!
@sasquatchgames7278
6 жыл бұрын
Hey Chris, Thank you very much for such a good tutorial. It's really helping me learn VBA a lot. You asked for suggestions for future tasks to create tutorials around with a variety of required key skills, and I think I have one: I have a task at work to create a macro that will take all of the information contained in a bunch of .csv reports in a particular folder, and put it into a sheet. Next, the macro has to create a pivot table out of that information. It would be absolutely awesome if you could create a tutorial around this task, because it's a bit of a head-scratcher for me at the moment. Thanks
@TigerSpreadsheetSolutions
6 жыл бұрын
Hi there and thank you for the positive comment. Yes, looping through files in a folder is a good idea for a video series, I will put it on my list. Good luck with your coding! Do check out the other videos on the channel...
@RafaelMDias-id2ou
8 жыл бұрын
What an amazing tutorial. Really helpful for me. Trying to improve the way we collect and store data on the vessel I work. I was using formulas in the cells and it was a little restricted. Now a whole new world of possibilities just appeared in front of me. Thanks a lot for the material and already looking for more on your web page. Please don not stop! Hehehe
@TigerSpreadsheetSolutions
8 жыл бұрын
+Rafael M. Dias Many thanks Rafael, plenty more to come this year ;-)
@fmengineeringspreadsheetso508
7 жыл бұрын
I have been downloading your tutorials, thanks very much sir. . .awesome,
@God.Sanatan
5 жыл бұрын
Great series of tutorials
@TigerSpreadsheetSolutions
5 жыл бұрын
Happy they helped, Vinod!
@keithlobo966
6 жыл бұрын
Thank You! Excellent Teacher and good material Presentation
@TigerSpreadsheetSolutions
6 жыл бұрын
Many thanks Keith and please do check out the other videos on the channel...
@randyhimura1
6 жыл бұрын
Awesome series of videos. I hope to learn more from your channel. Thanks!
@zazdw
6 жыл бұрын
All your videos have been very usefull for me, thank u very much!
@sureshkantikar
6 жыл бұрын
Thank you very much for the knowledge sharing. Very informative and well explained.
@TigerSpreadsheetSolutions
6 жыл бұрын
Thanks Suresh and good luck with your coding.
@giandenorte
3 жыл бұрын
I learned a lot even if it was created 5years ago.
@TigerSpreadsheetSolutions
3 жыл бұрын
Thank you and welcome to the channel! Still uploading today :-)
@Mick-qq1pi
5 жыл бұрын
I watched most of your VBA and macros videos and found them to be very helpful and easy to understand and learn from. Keep up the good work. My next mission is to use some of the concepts you taught and make my sheets open more data from what I select. For example I have 3 -7 test points to verify and every time I need to tabulate the data I have to manipulate the sheets to suit the selection like 3 for example and then 7 or 5. Can you be hired or do you want this as your next video challenge. Thanks heaps for the good videos.
@TigerSpreadsheetSolutions
5 жыл бұрын
Mick - many thanks, and good to hear the videos have helped. I need some more information to help you with that one - could you send me an email, ideally with an example file? Email address is on the website contact page. Cheers, Chris
@robinscanlon9593
5 жыл бұрын
great set of videos! Thanks!
@TigerSpreadsheetSolutions
5 жыл бұрын
It's a pleasure Robin - what other Excel videos would you like to see?
@arsalanahmad435
7 жыл бұрын
excellent video ..... very informative and you are right about it transform the I think about excel. Helping sheet is also very use full. thank you
@TigerSpreadsheetSolutions
7 жыл бұрын
Thanks Arsalan - do check out the other videos, and good luck with your VBA.
@maamidisowmyaa
4 жыл бұрын
wow Chris... u were really awesome.. GOD bless u :)
@TigerSpreadsheetSolutions
4 жыл бұрын
Thanks for watching :-)
@MrMarho
4 жыл бұрын
I watched this series 3 years back and I guess I got frightened or decided to use a manual INDEX-MATCH formula to solve my problem at the time. I did eventually delve into VBA for some problems later but it seems I am back. I must say, I like to way you break down the learning. It is quite informative and easy to follow for complete beginners. That being said, I have a question on this. Given that I had a condition for which to pull records from my table or database, how would one go about this? Also what if the condition was dynamic? For example, I wanted to pull records of employees from the data who have at least 15 years of service but tomorrow, I wanted to pull records of employees who have not more than 10 years of service. This would imply that your reference isn't absolute and the first record will be based on the given condition. The condition can be gotten using an inputbox, also the number of times to loop can be gotten using an in sheet formula but my major challenge is how to go from the first found record to the next record to be found. I look forward to your response. Thank you
@TigerSpreadsheetSolutions
4 жыл бұрын
Hi there - why no use a cell in the spreadsheet to define the condition (eg. more than 10 years service), then use a conditional statement in VBA to only create the record if years service is more than the number in the cell? That could work nicely - good luck.
@MrMarho
4 жыл бұрын
@@TigerSpreadsheetSolutions I understand this but the issue then occurs where you try to find the first match of your condition and then offset to the next row that meets this condition. This means your offset value is also dynamic. I may be going about it wrongly but these are the difficulties I seem to be facing.
@fermicosta
7 жыл бұрын
Great videos. Very useful and well explained. Greets from Portugal. Thanks!!!
@TigerSpreadsheetSolutions
7 жыл бұрын
Thanks Fernando! Good luck with your coding.
@siddharthmcwann4716
4 жыл бұрын
very well structured video, lucid explanations....thanks a ton for the lectures, they were really useful in my learning. Just wanted to ask if there is any reason for naming your channel as Tiger Spreadsheet Solutions.
@TigerSpreadsheetSolutions
4 жыл бұрын
Siddharth - you're welcome and thanks for the comment. Unfortunately there is no big story behind the Tiger name - me and my business partner at the time just liked the distinctiveness of it. It certainly means people remember you! (Oh no, not the Tiger guy again...) :-)
@jayosorno5689
5 жыл бұрын
thank you for the informative video.
@TigerSpreadsheetSolutions
5 жыл бұрын
You're welcome Jay!
@diegobermudez4789
6 жыл бұрын
Very interesting videos!
@ExcelWithChris
5 жыл бұрын
Thanks a million. Great start to VBA for me. Any series following this?
@TigerSpreadsheetSolutions
5 жыл бұрын
Thank you - check out the Excel VBA for Beginners playlist, around 50 videos on there, with more elsewhere on the channel, I hope it helps!
@sebastianbrudersohn5021
5 жыл бұрын
Super useful, thanks!!
@TigerSpreadsheetSolutions
5 жыл бұрын
You're welcome Sebastian, see you in another video on the channel
@jorgefernandoacostabarrios2997
6 жыл бұрын
Thanks so much. I am from Venezuela.
@michaelwu911
2 жыл бұрын
Amazing videos. Coding really made easy. Keep up the good work!
@TigerSpreadsheetSolutions
2 жыл бұрын
Thank you very much - see you in another video on the channel ...
@LM3_21
6 жыл бұрын
I have to say thanks, great videos. Really usefull.
@TigerSpreadsheetSolutions
6 жыл бұрын
Thanks Luis and please do spread the word about the videos!
@Mrkris2111
6 жыл бұрын
Great video series, thanks for uploading!
@TigerSpreadsheetSolutions
6 жыл бұрын
Thanks and good luck with your coding :-)
@Sagasoft-sl
4 жыл бұрын
Excellent Video.
@TigerSpreadsheetSolutions
4 жыл бұрын
Thank you - please check out the other videos on the channel.
@toldham2173
7 жыл бұрын
Hi Chris, I am new with the VBA and wondering if you could give a guidance on how to pick up a work sheet from multiple sheets workbook and save a copy into a folder, name the file to the name of current workbook with end of the week date. I have this task at work and found it so complicated to deal with. Thank you in advance. By the way so far your videos have helped me a lot! THANKS
@TigerSpreadsheetSolutions
7 жыл бұрын
Hi Tias - thank you. This sounds very do-able in VBA. As always, I would recommend going through the steps and recording the code, then reviewing and tweaking it. A combination of techniques from this series and some recorded code should get the job done - good luck!
@thitiponglo.8246
3 жыл бұрын
Amazing tutorial !! Cloud you please suggest, what if 1 sheet can hold 6 users then for the next user will be in the next sheet. sorry for my bad English.
@TigerSpreadsheetSolutions
3 жыл бұрын
You can do that with a well-controlled loop. I would recommend checking out our other videos to build your skills first ... good luck! Particularly check out the 30 for 30 beginner series.
@thitiponglo.8246
4 жыл бұрын
You are amazing !!! Quick question. What if I want to reverse the sequence of the duplicate sheets? Thanks so much.
@TigerSpreadsheetSolutions
4 жыл бұрын
Thank you and I think you're amazing for watching and learning! Try switching 'after' and 'before' in the copy code, this should change the ordering. Good luck!
@thitiponglo.8246
4 жыл бұрын
@@TigerSpreadsheetSolutions It's work !!! thank you so much, teacher.
@jessio4312
8 жыл бұрын
You are a very Handsome man .Thanks for Sharing .
@carbonblade1
2 жыл бұрын
Great videos thanks 👍🏻
@TigerSpreadsheetSolutions
2 жыл бұрын
You're welcome, Dave - see you in another video on the channel
@mauricetanquary2431
5 жыл бұрын
Extremely helpful, thank you.
@TigerSpreadsheetSolutions
5 жыл бұрын
Thanks Maurice, please check out the other video series on the channel
@jorgefernandoacostabarrios2997
6 жыл бұрын
que bueno esta este vídeo. gracias por enseñar. Saludos.
@amazon628
6 жыл бұрын
Amazing .
@gbnoob20
4 ай бұрын
You are Amazing!!!
@TigerSpreadsheetSolutions
4 ай бұрын
You're too generous! Welcome to the channel and see you in another video ...
@julianowak7196
6 жыл бұрын
Chris. May I kindly ask you to record a tutorial on how to split the active workbook to individual, independent sheets?
@TigerSpreadsheetSolutions
6 жыл бұрын
Hi Julia, thanks for the comment - do you mean separating sheets in a workbook into separate files? I am not absolutely sure what you mean - send me an email via the contact page if you'd like to clarify. Thanks for the video idea.
@sharmitajardosh7848
7 жыл бұрын
Great tutorial to learn VBA from beginning..Just had a question , instead of creating three different sheet , if I want to add the whole data ( say 15 ows) in one sheet , how to do that?
@TigerSpreadsheetSolutions
7 жыл бұрын
Hi Sharmita - it's certainly possible and code from this video is a good starting point. I recommend going through this code in some detail, and maybe some of the other VBA videos on the channel, to get some ideas. Also, try recording the required actions in the macro recorder and review / tweak the code to get it working. Good luck!
@brad151159
6 жыл бұрын
Hi Chris. Big thumbs up for the video. If I could make a suggestion for an additional video to this series (or if you could answer via a comment would be appreciated). There are 23 employees in the database. If an additional employee was added. How could the code handle that. When the code is run, bypass existing 23 employees because the sheets already exist and just add the new sheet for the new 24th employee. Hope this makes sense and Thanks in advance.
@TigerSpreadsheetSolutions
6 жыл бұрын
Hi Brad - thanks and thumbs up for your comment! Interesting question. I would suggest you use two spreadsheet cells to control the scope of the loop. Set up the loop so that it loops from the value in one cell to the value in another. Use something like: For counter = range("A1").value to range("A2").value Next counter This should allow you to include / exclude rows in the database as you require, by adjusting the values in cells A1 / A2. Thanks for the comment and good luck!
@StevenDelCastillo
6 жыл бұрын
Incredible, thank you!
@TigerSpreadsheetSolutions
6 жыл бұрын
Thanks Steven and good luck with your coding.
@iramineut
7 жыл бұрын
Great Stuff Tiger thank you so much !! i have 2 questions please 1- what code we need to put in order to avoid creating duplicates, i mean if an emloyee's sheet already exists, excel should move to the next line and check again 2- how can we make excel delete a sheet automatically if an employee's line is deleted from the database thanks again !!
@TigerSpreadsheetSolutions
7 жыл бұрын
You're very welcome sir! 1 - you would need to piece of code to check if there is a sheet already with the employee's details on. You could do this by looping through all of the sheets and checking the name of each; if the name of the sheet equals the employee's number then there is already a sheet for that employee. You could do this using a For Each loop and the activeworkbook.sheets collection 2 - it would be difficult (but not impossible) to delete a sheet if the employee's line were deleted. It would be much easier to include a 'refresh' button at the top of the database. Create some code to loop through the lines in the database and check against the sheets in the workbook; if there is a sheet in the workbook with no corresponding line in the database, delete it. Attach this code to the 'refresh' button Both of the mechanisms would require techniques covered frequently in the Tiger VBA videos - challenge yourself to implement them. Good luck!
@inconnuindefini8873
7 жыл бұрын
thank you for this awesome video
@TigerSpreadsheetSolutions
7 жыл бұрын
Thank you - please do share with others if you think it's helpful. Good luck!
@vinaysharma5675
8 жыл бұрын
Very Good video series. Simple and practical. Neat presentation Thank You for making this :) Just one questions do we need to use ".Value" at the end of say for example Activesheets.Range ("E8"), my code was running without it as well. Therefore what is the significance of .Value ?
@TigerSpreadsheetSolutions
8 жыл бұрын
+Vinay Sharma Thanks Vinay, glad it helped. .Value is a property of the ("E8") cell. Other properties could be the fill colour of the cell, or the address of the cell - there are many! If there is no property in the code (ie. Range("E8")), then Excel uses the default property, which is .Value. So, it should work without .Value, but generally it is good practice to use the property .Value, for completeness. msdn.microsoft.com/en-us/library/office/dn301006.aspx
@riaariarini8553
5 жыл бұрын
Thank you for the lesson. Love This. But I want to ask the question for the part 6, if we want to copy 100 sheets, then how to place the first copied sheet just next after the original sheet and the 100th copied sheet in the last ? can we do this automatically (not manual) ? because in your video, the last copied sheet (no 24) is placed just after the original sheet. Thanks
@TigerSpreadsheetSolutions
5 жыл бұрын
Ria - glad you like the lesson. Use something like: ThisWorkbook.Sheets.Count instead of the value to position the copied sheet at the back. Good luck!
@sandeeppeddi7075
5 жыл бұрын
@@TigerSpreadsheetSolutions Great job broh,,, U Are really amazing !!! I actually wanted to learn VBA yesterday and gone though few vedios. They just confused me and showed the course as so complicated and I thought it needs basics of multiple java courses But luckily today I found this series and After watching all 6, I got confidence I can learn even more and I can enjoy the course. Am surprised by watching your comment, helping your followers even further that too at free of cost. Hope u will continue your journey successfully.
@raydaley9252
6 жыл бұрын
Hi Chris, how would you delete a row in the database, also how to generate invoice number for each active sheet when duplicating your invoices
@TigerSpreadsheetSolutions
6 жыл бұрын
Ray - for deleting rows I would follow the usual approach: use the macro recorder to record the code, then tweak the code to get it working for you. Not sure about the invoice query... good luck!
@rickvdschootbrugge6893
6 жыл бұрын
Great video's, it helped me very much! Thanks a lot! However, I want to make my file more interactive for other users. With one click on a button I would like to delete a single entry from the database, and also delete this specific sheet? Do you have a smart solution for this? Thanking you in advance!
@TigerSpreadsheetSolutions
6 жыл бұрын
Hi Rick - this is certainly possible. - create a dropdown menu of all entries - allow user to select an entry and trigger a macro to delete it - get code to identify sheet according to user selection - delete the sheet and corresponding row in database They are the steps to work through. You would have to work through them one-by-one, testing as you go along. Good luck!
@shaunattwood2412
6 жыл бұрын
How would you change the Code to get the new tabs generated in order, instead of in reverse order? By the way, great videos, really informative!
@nathanoliphant906
5 жыл бұрын
You would need to add the counter to the current index number. See below. Sheets(2).Copy After:=Sheets(2 + (counter - 1))
@MrEms333
7 жыл бұрын
Nice thank you
@eyeitnowt1324
7 жыл бұрын
Great videos with an amazing dedication. Thank you for that. Can you please post a video of how to call a recorded macro autmaticly by vba coding. I have 5 cells. A1, A2, A3, A4 and A5. I have recorded a macro which copies the value of A4 and 10 cells below that paste it to A5. Than it copies the value of A3 and paste it to A4. That means it is a list with opdatet values, with the newst on the top of the list. Vba help needed. Now I want to call that macro from abov to work whenever the value of A1
@ayleono
8 жыл бұрын
Hi Chris, thank you very much for your videos, I love the pace and clear explanations. Quick question: I'm having issues with the DeleteSheet macro; when I execute it, it deletes every sheet but the first one; I've checked multiple times and my code is identical to yours. I found that if i set the index condition to > 3 (ie If ChrisSheet.Index > 3 Then ChrisSheet.Delete) it works as intended, leaving the first 2 worksheets untouched. Any idea of why this might be? Cheers, keep up the great work!
@TigerSpreadsheetSolutions
8 жыл бұрын
Hi there - thank you :-) if you send your file to me via the website contact page, I will take a look
@monica2787
5 жыл бұрын
do you have a series that shows how to add rows that can allow for inputs within a section of locked cells? ie columns B thru F are locked so they cannot be rearranged, but someone needs to have the ability to insert a new row along with data in columns B thru F for that new row. Thx!
@TigerSpreadsheetSolutions
5 жыл бұрын
Monica - I don't think that would be possible without unlocking the cells, are they password protected, and do you know the password?
@monica2787
5 жыл бұрын
@@TigerSpreadsheetSolutions so I want to lock the cells and password protect them so the people using the template cannot rearrange the order of the rows but i still need them to have the ability to insert a row for a new item if/when needed...
@TigerSpreadsheetSolutions
5 жыл бұрын
Monica - I think you would need a macro to: - unprotect the sheet - insert a row - reprotect the sheet This would be my approach - give it a try!
@cdub22222
7 жыл бұрын
I am going through and following along with my own data, and I tried replacing the ActiveSheet.Range("A2").Value = Sheets(1).Range("A2").Value with ActiveSheet.Range("A2:V2").Value = Sheets(1).Range("A2:V2").Value in order to copy multiple cells into the new worksheet, but none of the data is appearing in the new sheets. Why is this, and what should I be changing in order to make this work for a group of cells instead of just one?
@lillianasanchez5984
5 жыл бұрын
I do have a question: I think it was asked below as well, can you be so kind and comment on how to change the order of the sheets? Because now we have all the sheets but in last to first order. I think you mention that you will explain it later in min 20:28 . You just need to leave a comment and we will all understand :)
@TigerSpreadsheetSolutions
5 жыл бұрын
Liliana - use 'worksheets.count' instead of the sheet number. That should working with some tweaking.
@raydaley9252
6 жыл бұрын
Great video. Just what i was looking for. Do you have any videos that now turns each sheet into a pdf and send bulk mail. I have over 20 employees that i send their payroll invoice to every 2 weeks
@TigerSpreadsheetSolutions
6 жыл бұрын
Hi Ray - thanks. I am currently editing a video series on separating worksheets into separate files - this should help you, look out for it!
@raydaley9252
6 жыл бұрын
@@TigerSpreadsheetSolutions Thats great. I will certainly look out for it. I'm almost done watching and implementing what I've learnt on adding and editing entries to my database. I just started a virtual call center and my database is growing daily. Ofcourse i haven't started making a re turnn yet so these vids really came in at the right time where i can utilize my time for efficiently These videos are amazing and learning alot in the process. I really appreciate it
@elysiumfire4230
6 жыл бұрын
Hi There. Excellent presentation and articulation on using elements of VBA within Excel. At work, I have been tasked to create an Excel database of electrical company assets that are dotted around the building. This particular series of videos has given me plenty of food for thought. I downloaded the spreadsheet for this series and worked through it with you, but what I would like to ask is: could the 'Employee Review Report' be placed on the same page as the source data and used simply for interrogation for single employees (but in my case - company assets), and to have a 'clear report' button so that it can be interrogated again? I would like this so that a company asset can be located on a diagram of the company building, giving asset position within the building, make, model, serial number, company asset code, employee it has been assigned to, etc. Many thanks for any advice you can give.
@TigerSpreadsheetSolutions
6 жыл бұрын
Hi there - thank you and yes, what you are trying to do sounds possible. It sounds simpler than what we do in this series because additional sheets would not be needed. You would just have to create the report in the format you require, make sure you 'clear' the report, then populate the report using code, as demonstrated in the video series. I like your idea for visual presentation too - good luck with it.
@heathfagan2149
4 жыл бұрын
Was wondering if anybody could tell me how to look up a specific account number and then have the duplicate sheet macro run for that single account. I understand the delete sheets and how to duplicate many sheets beginning with the first acct number on the data sheet, but i am curious as to the code to duplicate a single sheet if i enter an account number on the main data sheet in a cell similar to the counta. Thank you.
@TigerSpreadsheetSolutions
4 жыл бұрын
Hi Heath - the code in this series gets you pretty close. You would have to add a cell to input an account number, and a conditional statement in the code to ensure the sheet is only created if the account number matches a column entry. I hope this helps and good luck!
@heathfagan2149
4 жыл бұрын
Tiger Spreadsheet Solutions Thank you for the response.
Пікірлер: 236