Excel VBA for Post-Beginners: (6/6) Create Reports Using VBA - Full Demo

[@monitoring_evaluation]

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!

[@johnmazzella9198]

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]

Hi John - good to hear the videos are helping. Please do share the videos with somebody else whom they might help. Good luck!

[@kurtturner5120]

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]

Thank you so much, Kurt! Do check out the other videos on the channel.

[@peternganga9371]

"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]

Really appreciate the comments! Thanks.

[@sandeeppeddi7075]

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]

Sandeep - very happy you found us and the that videos are helping :-)

[@TonyK55]

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]

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.

[@krg1605]

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]

Thank you - and that's a great addition to the code

[@stevenlagoe7808]

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]

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!

[@carolliu5713]

Very helpful after I attended a two days face to face training

[@TigerSpreadsheetSolutions]

Happy it helped :-)

[@aliciakiansmum905]

Really useful introduction to VBA, being a complete novice I need this kind of baby steps approach.

[@runwiththerunners8152]

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]

It's a pleasure and welcome

[@eberkamuti1862]

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]

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!

[@haleshtalawar3656]

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]

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.

[@walle2024]

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]

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!

[@psclhys]

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]

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!

[@safajamal5748]

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]

Thank you Safa - there are many more VBA videos on the channel, enjoy!

[@venkatramana3258]

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]

+Venkat Ramana Many thanks Venkat - more videos to come this year, good luck!

[@m0209]

very valuable information, and I appreciate the pace at which you explain the material. thank you!

[@TigerSpreadsheetSolutions]

You're very welcome - do check out the other video series

[@m0209]

@@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

[@serhiiminin5132]

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]

Hi there - thank you! There are many more advanced applications on the channel, I recommend our 'VBA for Beginners' playlist. Enjoy the content.

[@ankitshah6591]

sir, this is the first video I watched of you and I like your teaching style very good. Thank you sir

[@TigerSpreadsheetSolutions]

Thank you Ankit - there are plenty more for you to watch, good luck!

[@Mick-qq1pi]

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]

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

[@lizo4845]

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.

[@alisond7395]

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.

[@GoldenShorts871]

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

[@hansvanleeuwen9524]

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]

+Hans van Leeuwen You're welcome Hans - good luck with the coding!

[@rhymiekollie5190]

hi

[@johnl9408]

I have always wanted to learn some coding. Thanks for the videos, I will be going thru them all. Great instructor.

[@TigerSpreadsheetSolutions]

Great to have you on the channel John, good luck!

[@userme2803]

Excellent video. Thank you. Can you make more video like that showing or resolving real-life problems/scenarios. Thanks again.

[@TigerSpreadsheetSolutions]

Thank you - you can find plenty of videos like this on the channel, enjoy!

[@maguedsedra]

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]

Hi there - thanks for the kind comment. Please do spread the word about the channel :-)

[@lillianasanchez5984]

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]

Lilliana - good to hear about your progress. Please do tell somebody else whom the videos might help about the channel.

[@jamesbarnett5236]

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]

James, great to hear - practice is key, so keep it up!

[@thitiponglo.8246]

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]

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.

[@pingyan80]

Just want to say Thank You! Have gone through the basic and advanced tutorial. They are really helpful!

[@TigerSpreadsheetSolutions]

You're welcome - please do share the videos with somebody else whom they might help :-)

[@joseluisvelarde8051]

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]

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.

[@wasimbader9170]

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]

+Wasim Bader Thanks Wasim, glad to hear that it helped. Good luck with your studies.

[@ExcelWithChris]

Thanks a million. Great start to VBA for me. Any series following this?

[@TigerSpreadsheetSolutions]

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!

[@aaswijesekara5272]

i watched the full series,excellent explanations . i hope you can do series with access .Thank you , i'm from Srilanka.

[@TigerSpreadsheetSolutions]

Many thanks. It's Excel only for the timebeing I am afraid. Good luck with your coding!

[@rayhitchcock4899]

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]

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.

[@user-pf4rx4rd8y]

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]

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!

[@MrMarho]

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]

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]

@@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.

[@ericgottlieb8275]

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]

Great to hear Eric, keep it up!

[@thitiponglo.8246]

You are amazing !!! Quick question. What if I want to reverse the sequence of the duplicate sheets? Thanks so much.

[@TigerSpreadsheetSolutions]

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]

@@TigerSpreadsheetSolutions It's work !!! thank you so much, teacher.

[@toldham2173]

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]

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!

[@sharmitajardosh7848]

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]

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!

[@sasquatchgames7278]

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]

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...

[@johnpetersay2421]

Awesome series of videos. I hope to learn more from your channel. Thanks! John from Sri Lanka

[@TigerSpreadsheetSolutions]

Many thanks John, good to have you on the channel!

[@hi2832]

Very well presented. I wish I could have found this few years back.

[@TigerSpreadsheetSolutions]

Great to hear Raheel and welcome

[@powerstar817]

This is a very best place to start and finish vba and I really like the way of teaching its really awesome !!!!!

[@TigerSpreadsheetSolutions]

Thanks Vijay! Please do spread the word about the Tiger channel...

[@powerstar817]

ill do it definitely!!

[@siddharthmcwann4716]

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]

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...) :-)

[@brad151159]

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]

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!

[@iramineut]

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]

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!

[@fmengineeringspreadsheetso508]

I have been downloading your tutorials, thanks very much sir. . .awesome,

[@metalpower18]

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]

Hi there - great to hear you have started learning VBA! Plenty more videos on the channel, good luck.

[@DarknessChampion]

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.

[@mudit21bareja]

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!!

[@joemorris1282]

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]

Many thanks Joseph and good luck with your coding!

[@metalpower18]

Hello Chris, could you please help me? I am trying to copy data from a worksheet to another but I get an error "Subscript out of range", I used the following code : Workbooks("pathname to file").Worksheets("Key Metrics").Range("A1:A20").Copy Can you please tell me what's wrong with this line? Thanks!

[@TigerSpreadsheetSolutions]

Hi there - it is most likely there is a problem with the name of the worksheet- check that the worksheet name is accurate

[@metalpower18]

Thanks for the answer, the names are correct, apparently the problem is due to the xlsm file not "seeing" the other xlsx files I am trying to copy from/to, I also tried running the code from the personal workbook but it returns the same error :/

[@zazdw]

All your videos have been very usefull for me, thank u very much!

[@rickolin]

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]

Cheers Nick - very happy to have you on the channel

[@randyhimura1]

Awesome series of videos. I hope to learn more from your channel. Thanks!

[@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!

[@cdub22222]

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?

[@ayleono]

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]

Hi there - thank you :-) if you send your file to me via the website contact page, I will take a look

[@keithlobo966]

Thank You! Excellent Teacher and good material Presentation

[@TigerSpreadsheetSolutions]

Many thanks Keith and please do check out the other videos on the channel...

[@RafaelMDias-id2ou]

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]

+Rafael M. Dias Many thanks Rafael, plenty more to come this year ;-)

[@sureshkantikar]

Thank you very much for the knowledge sharing. Very informative and well explained.

[@TigerSpreadsheetSolutions]

Thanks Suresh and good luck with your coding.

[@riaariarini8553]

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]

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]

@@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.

[@alexandrumarcel3696]

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]

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!

[@rickvdschootbrugge6893]

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]

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!

[@k.essamkhwaleh9441]

Many thanks and great work Can I know what program you use to record videos???please

[@TigerSpreadsheetSolutions]

Hi there - I use XSplit Recorder most of the time these days, and sometimes use Icecream screen recorder. Use Icecream if you just wish to record your screen, use XSplit for something more advanced such as capturing your webcam too. I had a bad experience with MovAvi so I do not recommend them.

[@k.essamkhwaleh9441]

thanks for your repley

[@elysiumfire4230]

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]

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.

[@vinaysharma5675]

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]

+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

[@arsalanahmad435]

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]

Thanks Arsalan - do check out the other videos, and good luck with your VBA.

[@julianowak7196]

Chris. May I kindly ask you to record a tutorial on how to split the active workbook to individual, independent sheets?

[@TigerSpreadsheetSolutions]

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.

[@God.Sanatan]

Great series of tutorials

[@TigerSpreadsheetSolutions]

Happy they helped, Vinod!

[@shaunattwood2412]

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]

You would need to add the counter to the current index number. See below. Sheets(2).Copy After:=Sheets(2 + (counter - 1))

[@robinscanlon9593]

great set of videos! Thanks!

[@TigerSpreadsheetSolutions]

It's a pleasure Robin - what other Excel videos would you like to see?

[@LM3_21]

I have to say thanks, great videos. Really usefull.

[@TigerSpreadsheetSolutions]

Thanks Luis and please do spread the word about the videos!

[@raydaley9252]

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]

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!

[@Mrkris2111]

Great video series, thanks for uploading!

[@TigerSpreadsheetSolutions]

Thanks and good luck with your coding :-)

[@raydaley9252]

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]

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]

@@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

[@fermicosta]

Great videos. Very useful and well explained. Greets from Portugal. Thanks!!!

[@TigerSpreadsheetSolutions]

Thanks Fernando! Good luck with your coding.

[@luismanuelcaprilesguerra5219]

Hello Tiger, Thanks for this tutorial. How can I apply the same methodology to create reports in a new workbook ? BR

[@TigerSpreadsheetSolutions]

Hi Luis, that sounds like a good topic for a video series! Try copying the sheet to a new workbook and recording the code for this. Then, step through the code, tweak it and see if you can get it working how you want. Good luck!

[@maamidisowmyaa]

wow Chris... u were really awesome.. GOD bless u :)

[@TigerSpreadsheetSolutions]

Thanks for watching :-)

[@AlfraRed]

What I am not sure about is why I had to activate the sheet, as I found trying to run the macro from the test sheet was causing an error.

[@diegobermudez4789]

Very interesting videos!

[@monica2787]

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]

Monica - I don't think that would be possible without unlocking the cells, are they password protected, and do you know the password?

[@monica2787]

@@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]

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!

[@mauricetanquary2431]

Extremely helpful, thank you.

[@TigerSpreadsheetSolutions]

Thanks Maurice, please check out the other video series on the channel

[@eyeitnowt1324]

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

[@jyotijain5157]

First of all thanks a lot for these amazing tutorials. I wanted to calculate valuation of some 3000 companies. I have data in one worksheeet, and the formulae to calculate in two different worksheets. The task that i want to accomplish is input the variables into the two worksheets with the formulae for every company and make new worksheets for each company. Is that possible?

[@TigerSpreadsheetSolutions]

+Jyoti Jain It is possible, and the task sounds very similar to what I do in this tutorial series. You may experience some problems with workbook limits. You cannot have 3000 worksheets in a workbook, as far as I know. So, you would have to 'batch' the data (rows of 200 maybe), or create new workbooks as you go along. The best way would be to start small and build up - get it working for one company first, then scale up from there. Here is some information about Excel capacity limits: support.office.com/en-us/article/Excel-specifications-and-limits-ca36e2dc-1f09-4620-b726-67c00b05040f#bmworksheetworkbook

[@jyotijain5157]

+Tiger Spreadsheet Solutions Thanks. I am still facing some problems. You don't have more tutorials?

[@TigerSpreadsheetSolutions]

+Jyoti Jain Everything we have is currently on the KZbin channel, but there are more coming this Summer. What particular topics do you think would be useful?

[@jyotijain5157]

I am very new to excel. From a beginner point of view I think automation of calculations using multiple worksheets and Usage of charts, combining different charts to make a completely new form of infographics, e.g Speedometer. So far I have found these videos very helpful. I would like to add this, your tutorials are the most neat of all I have come across so far.

[@TigerSpreadsheetSolutions]

+Jyoti Jain Many thanks Jyoti, I appreciate the kind comments. Keep an eye on the channel over the summer, plenty more to come...

[@sebastianbrudersohn5021]

Super useful, thanks!!

[@TigerSpreadsheetSolutions]

You're welcome Sebastian, see you in another video on the channel

[@jayosorno5689]

thank you for the informative video.

[@TigerSpreadsheetSolutions]

You're welcome Jay!

[@giandenorte]

I learned a lot even if it was created 5years ago.

[@TigerSpreadsheetSolutions]

Thank you and welcome to the channel! Still uploading today :-)

[@jorgefernandoacostabarrios2997]

que bueno esta este vídeo. gracias por enseñar. Saludos.

[@jorgefernandoacostabarrios2997]

Thanks so much. I am from Venezuela.

[@Sagasoft-sl]

Excellent Video.

[@TigerSpreadsheetSolutions]

Thank you - please check out the other videos on the channel.

[@carbonblade1]

Great videos thanks 👍🏻

[@TigerSpreadsheetSolutions]

You're welcome, Dave - see you in another video on the channel

[@StevenDelCastillo]

Incredible, thank you!

[@TigerSpreadsheetSolutions]

Thanks Steven and good luck with your coding.

[@lapointe64]

Since you are using counter as an offset, why not just start your loop at 0 and then offset by counter, rather than start at 1 and offset by counter-1 ?

[@TigerSpreadsheetSolutions]

Yes I think that would be possible. I suppose starting at zero feels a bit unnatural to me, but it 's a case of personal preference. Good luck!

[@heathfagan2149]

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]

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]

Tiger Spreadsheet Solutions Thank you for the response.

[@cristianscript5649]

I can't get this code modification to work and it always show error What the heck I am doing wrong Sub DeleteSheet() Dim variable As Worksheet Application.DisplayAlerts = False For Each variable In ActiveWorkbook.Sheets If variable.Index 1 Then ElseIf variable.Index 2 Then variable.Delete End If Next variable Application.DisplayAlerts = False End Sub Thanks in advanced

[@TigerSpreadsheetSolutions]

Chris I recommend not using 'variable' as a variable name! Using something like ChrisSheet... Substitute your if statements with this: --------------------------- If ChrisSheet.Index 1 then If ChrisSheet.Index 2 then End if End if --------------------------- Good luck. Chris