Hey, good morning everyone. Welcome to the session. Let's begin this time with the word of prayer, then we will get into our teaching. Would any one of you like to please lead a prayer? Sally, would you mind leading us in prayer or Rosalind? Anyone can lead us in prayer, please. Let's pray. Father, we come before your presence in the name of Jesus as we begin our class for today. I pray that you will help us Holy Spirit, your blessed pastors as it teaches us this morning also and bless each one of us, Lord. We thank you, we bless you, we all know you Lord. In Jesus' name, amen. Right. Thank you so much, Sally. All right, so just a quick review of what we did last week. Last week we looked at chapter 7 and chapter 8. Chapter 7, we looked at the cell as your ministry team.  You have seed projects that you can do, outreach is involved in Sunday services. And we also very importantly, chapter 8, we looked at pitfalls to avoid. Right now, we looked at quite a few of them. How you and I as leaders can avoid things that can cause a cell group to be unfruitful or to even just break. And we talked about some of them avoid shortcuts, avoid competition, watch out for people with personal agendas. Remember we talked about that, then people will come from independent ministries, be careful. You are the shepherd of those 12 people or 15 people, whoever you're looking after. So you are the one who must be willing to protect them and cover them. Then you look after independent ministries, that meaning you be careful, don't just invite whoever you feel like, personal prophecies and then don't force newcomers to come. Don't relinquish your leadership. And so you may have people who are much more mature than what we are. But don't just relinquish your leadership, don't hand over the teaching of the word to, just because somebody knows more. So you and I must understand that God has called us. We are journeying to a certain level of maturity and time we will get there. So don't worry about that. Don't allow the cell group to become a hindrance in your family. And it's very important because in the name of ministry, we can go about doing a lot of things and then miss out on the family aspect. And that's not what God wants. Expects us to maintain a good balance between ministry and family. Okay, let's get into Chapter 9. Now, Chapter 9, we're going to look at the administrative side of things that is cell administration. Let me just present the notes and cell administration now. The word administration simply means to oversee and to look after. So initially, when you start a church, when you start life groups, you may have maybe three or four life groups and normally the senior pastor just handles it or he finds a few volunteers who can oversee the life groups. But over time, as your church grows, as you have many more life groups, it is very important to look after the administration. Meaning, one thing, first thing we may have to do is to appoint a cell group pastor or a life group pastor. Now, what will be his or her role? The life group pastor, number one, will have to oversee the cell groups that are there, the life groups, and make sure that the life groups are functioning well, make sure that people are getting connected to the life groups, ensure that life groups are being effective, they're following protocol, things are going smooth, the leaders are able to minister to the people who are attending the life group. So, if you see here, you have a certain structure. So, firstly, you must have a cell pastor. And with the cell pastor over time, I would say probably when you are 20 life groups, eventually, as a church, you can plan on appointing associate cell pastors. Now, we've just named it cell pastors here, so you can also call it life group pastor or associate life group pastor. So, cell pastor, then over time, you have associate cell pastors. Let me explain what we are doing here at ATC. It's a very similar structure. We have a life group pastor or coordinator, and then what we are going to do is we are going to have zonal leaders. And these zonal leaders will have, under them, will also have area coordinators. Now, don't get confused. So, this is when we are thinking long term. So, right now, we have about 41 life groups. And so, I believe that 2024, if we start another 10 life groups, we will have 50 life groups. So, what we want to see, what we envision is that we're not going to go into having an associate life group pastor, but what we thought was we will have zonal leaders. So, probably, we have five zones in our city. So, North, South, East, West and Central. So, we divided the zone into five. And eventually, what we thought was we will handle probably five life groups to five zonal leaders. And so, it would be their responsibility to oversee these five life group leaders. Now, over time, if we eventually will reach about 100 to 120, 130 life groups, under the zonal leaders, we will also have area coordinators. Right? And then, probably, what I'll do next class is I'll probably make a, you know, just a presentation and show you what, what is, how we plan to do this. And right now, we are on cell pastor, that's life group pastor and zonal leaders. And then what we'll also have is area coordinators. And each area coordinator can probably look at five or six life groups. So, why are we doing this? Right? So, as a life group coordinator, I will not be able to oversee all 40 or even as we grow, maybe 50 to 100 life groups. So, we get people involved, right? And eventually, over time, we will also plan to have an associate life group pastor, but we thought we can use our church folks, right? And many of them have been life group leaders for years. So, we train them. And let's look at, you know, some of the responsibilities that these cell pastors and associates cell pastors have, right? So, we know that. So, again, this is an ABC 12 cell, 12 in each group. Okay. So, what will he or she, that is the associate cell pastor, or in our case, the zonal leaders, what would they have to look at this? First one, your cell pastor will be in touch, associate cell pastor or your cell pastor will be in touch with you on a weekly basis.  Were there any queries? Were there any questions? Now, think about this. Can a, you know, can one person call like 50 life group leaders and talk to all of them? It's not going to be easy, right? Especially when you have other tasks as well. And so, that is why getting administration, getting people to get involved, especially when the ministry grows, administration is very, very important, right? It ensures that you're in touch with everyone that is constant fellowship. It's not like, okay, they meet once in two weeks. So, we'll call them once in two weeks. No, it doesn't work that way. If we want to see the cell group be effective, we must be willing to speak into their lives, minister to the leaders, and only then the leaders will be able to minister to their life group members, right? So, that's why an associate cell group, cell pastor or a zonal leader is very important, right? Now, this zonal leader, the associate cell pastor will keep, will closely work with the main cell pastor. So, he will probably send reports, right? Okay, this is what is happening. We have these life groups. There are certain life groups that, you know, sometimes people travel, they go, they move out of country, or they want to take a break. And so, everything, all the information comes to the cell pastor. And the cell pastor makes decisions, gives advice as to what can be done, right? Again, as an associate cell pastor, you can request your cell pastors for lessons, resources. But in case of APC, what we do is, as you know, we follow the Sunday sermon. But you're always free to, you know, discuss whatever is on your mind. But again, this, you must ensure that it is being always, it's being overseen, right? So, so the, whatever we are studying and teaching, remember, it's going to affect the church, it's going to affect church people, people will are going to, you know, listen to you and they go into, as leaders, they're going to receive from you. So we got to make sure that what we teach is right and in line with the word of God, right? And then, you know, as a cell pastor or zonal leader, right, you can visit your cell groups periodically. If you need additional help, like counseling, visiting, raising worship, you can always contact your cell pastor. So for example, you know, there was this, there was this life, couple of life groups actually, they don't have somebody who can play an instrument. So I remember, they got back to me and said, you know what, said, look, the life group is really good. But what we miss is worship times, right? We don't feel good by just playing a couple of songs on the laptop.  Now, that was a request that came in. And so then what I did was I checked with our worship pastor. So is there anybody living in this side of town? So is it north, Bangalore, southeast by which area? Okay, whichever area, we tried to find somebody and we requested them if you can just go and lead the worship. And so we were able to get people to, you know, just go and, you know, people were available, right? I'm not saying every time people are going to be available, but there'll be times, you know, people are working. But since most life groups meet on Saturday, we were able to send people, they went, they lead the worship and they still go to a few life groups and eat worship. So your cell pastor or your associate cell pastor is somebody who must be able to, you know, I won't say pull strings, but be able to coordinate and be able to, you know, make sure that the health of the life group is good, right? Again, going to health, we have cell leaders feedback form, right? So for example, what we have is we have LG report at abcwo.org. So what happens is if people would like to write in about their leaders, if they want to be anonymous, they just write it and say, okay, this is something that I feel the cell group must do. This is something that they shouldn't do. And so we do get feedbacks, right? So regarding the feedback form, this is something that we have stopped as of now because we don't want to use paper. So we try and put that online. And so people can either email us or they fill in the feedback form and email it back to us, right? So all of this is available online as well. And then every once in three months, we do a cell health assessment. So meaning is the cell group, I know three months could be a short time, but is the cell group able to coordinate with each other? Are people in the cell group growing? Are they learning? Are they able to understand? Are they able to build fellowships? And so what we have done is we moved from three months to six months as well. So we do a three month, six month and a one year, right? Now after a year, we as cell pastors, we just slowly step back, meaning we give this life group leader more freedom to make decisions. It's not like they don't have freedom initially. It's just that we are there to always help them take the right decision or take the right step. We're always there, but slowly we let them make the decisions because if we are always there, they will keep coming back to us. What should I do? But again, when we look at discipleship, it is to let them make decisions. And when they make the decisions, they learn if it's a good decision, that's wonderful. You applaud them. It's a decision that, okay, could have been taken later on or so, not why is decision. So let them learn from their mistakes and as pastors and leaders, we help them to understand that and they learn from their mistakes. Right? So this is the administration side. You've got a life group pastor, or a cell pastor, associate cell pastors looking after cell. As I mentioned, you see, we don't follow it yet, but instead of associate cell pastors, what we're doing is Zolan leaders, five Zolan leaders, area coordinators under them. So even if we reach 200 life groups, we will have enough people. But what are we doing now? I think it was last September or October where we had a meeting with all our life group leaders and we shared the whole plan, the vision and people gave in their names. We also appointed a few Zolan leaders. So we've got that in place and so eventually we're going to also sign some of the life groups to these Zolan leaders and then appoint more area coordinators. So if you look at it, the structure is coming into shape right now. We will again, since it's something that we're doing now, it's something that we may have to work with trial and error. We have to make decisions. We have to figure out how things go about, but nothing wrong in trying all of this. So what are you doing? You're setting in place a structure for the cell group industry. So if you go on to the next page, we see here the cell leaders feedback form. Now this is just an example. So you can use it if you'd like in your cell groups if you already have one. You want to make it available on paper. You can if you want to just make it available on the phone or just on WhatsApp. Probably you can take this structure and then you can send it to your life group members and ask them to fill in the details and in that way you're assessing your life. So you can do this probably once in three months, once in six months or even yearly. If you go down here, you also have a little bit of space here. You purposely left that so that people can write feedback, whatever they feel like about the life group. Now why is this important? Because it gives opportunities for people within the church, within the cell group to share their thoughts, what they feel about life group, what they've learned. So again, this is not a compulsion but this is something that you can write and it's just like you're making sure that the life group is functioning, making sure that you're able to grow and the health of the life group is strong. Okay, so let's get into chapter 10. Chapter 10 is becoming a cell church. Now I know many of us may already be, we're already part of churches wherever we are. So your church may be a regular church doing many events or your church may be like a cell church which is a church which focuses only on cell groups. Now it doesn't mean that we have to, if you're a regular church doing many events, it doesn't mean you have to change to become a cell church. You can continue doing that but what we also like to emphasize is that remember that the cell group is the life of the church. It is what keeps the church strong. It is what builds community and discipleship and this mentoring, this leadership, there's all kinds of activities going on in a church. That's the life of the church. So how can you and I become a cell church? Now some of you may say, I don't want to become a cell church. I want to be a church doing many events and just have cell groups, many cell groups. That's wonderful. So, or some of you may feel, no, I want to have a church which will have at least 100 cell groups and through the cell groups we'll do ministry. That's also wonderful. But we'll just look at a few aspects here on how we can become a cell church. Number one is change. To become a cell church there has to be a change of perception of how a local church operates. We need to understand that what we are really doing is restoring the principle that was set in the early church. And so remember we looked at that, I think it was chapter 2 where we looked at the early church where they met in smaller groups. The Lord Jesus ministered to thousands but he also made sure he's ministering in smaller groups. If you're already a cell church, that's wonderful. You don't need change. I can continue growing as a cell group, as a cell church.  We have a church but we do many activities. We've got men's ministries, youth ministry, women ministry, workplace, professionals ministry, teens ministry. We have conferences throughout the year, events and conferences. Now we cannot say, okay, let's stop all of that and only focus on life groups. We can't do that as a church. But what we did was in early, I think it was 2015, we just tried to bring in more focus in 2014, bring in more focus into life groups. So from 2014, we're trying to build the life group ministry. So we started finding leaders, recognizing potential leaders, giving them opportunities to start life groups, recognizing areas within our city which need a life group and helping people to start life groups. So we started putting a lot of focus into life groups but what about the other ministries? The other ministries also continue. So the same as what we're doing now. Now as a church, we have all other ministries going on. So what are my responsibilities as a life group coordinator? So all 42 life groups. The vision is at the end of this year, we should have at least another 15 life groups. So we have 42 plus 15, that's 57 life groups. And so that's the vision. And so what about the other things that we are doing? That continues. But then we want to see focus on life groups as well. Continuously raising up quality leaders. This is something that we always focus on. Remove insecurity in the hearts of cell leaders through proper training. A proper and total training system must be put in place. So what we do is when a person says, okay, we recognize a person and I say, okay, this person can be a good life group. Sometimes what we do is we ask the person to go attend a life group for about three months, get a feel of what a life group is.  In fact, even after this call, I have a life group leaders training. So we go through the entire life group leaders training manual. A lot of it is taken from the snorkels as well. So we talk to them about what is a life group? Why are we doing this as a church? How are we impacting the vision? What is the administration side? Discipleship? How do we raise up new leaders? We go through the entire structure of life group. Now the person may know it. The person may not know it. It doesn't matter. We go through the whole thing. So for example, last month, a person, one of our church folks, he was saying, hey, I want to start a life group. Now he's been with our church for 10 years. But we went through the entire life group leaders manual. Many of the things that I know that he knows it. But it's important to reiterate. It's important that we train them well. No proper leadership development track, sorry, no proper leadership development track hinders growth. With no proper leadership, growth is being hindered. We need to ensure that there are sufficient number of newly trained leaders ready to take on leadership. So let me give you some examples on what I do. So how can I start off 15 life groups? Now it's easy to give a number, 15 life groups this year. So we break it down. From the month of January to June, six months, I should have started at least maybe seven life groups. And then from July to December at the eight life groups. So that's what, so I'm mentally prepared myself. Seven by Jan to June, eight from July to December. Now, how do I start seven? What can I do? So what I do is I open our church database and I look at, I also open our maps, the map of the city. And I try to look at places where we don't have a life group. So I put a note of it. So these are about 10 areas where we need life groups. Then I look at youth life groups. So we have so many youth living all across our city. And these are few of the areas that we need to start youth life groups. So now I've got the numbers in my mind. Gotta start seven or eight Jan to June. Now I've got the areas in place. Okay, these are some of the areas.  So I make a note of potential leaders. Now all I'm doing is I'm making a note of them. Probably I write them down, put them on a world document. Right. Now after I do that, I have about maybe five people in mind. So I begin to talk to them and say, Hey, you know, this is something that we need that are life groups. Sometimes they don't even know what is a life group. They may not have heard what happens in a life so you'll have to start off from scratch. We need to explain to them, you know, this is what it is.  Right. Don't be discouraged when people say no. It's okay. You can just strike off their name from that list, right, but continue to look up. When people say give me some time, ask them how long they would like, right. So normally I tell them, can I, can I get back to you in a month's time? A month is a good amount of time. So give them a month's time, let them think about it. And then probably they get back or we try and connect them. Three is, you know, we, after we give them, then there are people who say yes. So then what we do is we again, we encourage them to be part of a life group if they are not, then probably after two or three months, we take them to the training and help them to start the life group. Right. So, so it's, you know, even to start one life group, it's, it's not as easy as it looks because people are working Monday to Friday and they'd like their Saturday Sundays to be free. Right. So not everyone would be open. So here comes the place where as leaders, we must recognize people who are willing to sacrifice, willing to give that additional time. Right. So that's what I do. And then firstly, what I also do is I, I call the existing life group leaders and I say, hey, everyone give me one person who is a potential life group leader in the year 2024. Right. So I did this in early Jan. I spoke to all the life group leaders, 40, 40 life groups is what we have early Jan. So 40 life group leaders. Give me one person who is ready to start a life group. So I've got about 20 names now. 20 to 22 names who are potential life group leaders. I was, I'm not saying that all 22 of them will start for their potential. So we know that, okay, they're already part of a life group. They're part of ABC. They know what a life group is. So if not 24, 25, at least we can, you know, train them and, you know, disciple them and get them to start new cell groups. Right. So that's how I personally work. Right. So, so for example, from Jan, now it's February. So we've already started two life groups. So in my mind, I've got March, April, May, June, four months. I've got to start at least another five life groups, five or six life groups, four months. Right. So now today I have another life group leaders trainings. So that's, that's going to be the third life group for this first half. Right. So you just break down and plan accordingly. Right. And a standard. So the point is we should have sufficient numbers of leaders. It should never be in a place where we don't have leaders to lead a life group. Then you have a standard training, which is, which is something that we already do. Teach the cell leaders to prepare properly. We talked about it. We provide material as well. The energy and resources of the church must flow in the same direction. I mean, as a church as well, you know, we make sure that, okay, even life groups are very important.  We need to start more life groups. We are building a vision. We're walking together. So it's not always two separate entities. So when you look at a cell church, it's like a two-wing burn. Right. So you have the cell meetings and you have the Sunday celebration services. And both are important. Again, something that we want to do in our life groups is that, and we always, I always emphasize this is to be excellent. And so don't look at, just because there are three or four people, let's just do it the way we feel like doing the excellent life. Even as a leader, if you're preparing for your, if you're preparing for your discussions and Sunday sermon, preparing for the excellent life, prepare well. Don't come in just like that, say, okay, I'll just say something, no, prepare well. Because even with the three or four, be faithful and no small. So when you have bigger opportunities, more people coming in, you know that, okay, I have to prepare well, I have to deliver well. So people will be blessed. And so that is something that we always emphasize. So it's not like, okay, church service should be excellent, but cell groups, you can do it however we feel like, no. Even our life group leaders meetings, we follow a structure, we follow agenda.  No, we have an agenda. So for example, we have our life group leaders meeting in March. The date is March 22nd. So yesterday I sent a message out to all the life group leaders saying, we're going to meet on this Sunday, March, and this is the agenda, the agenda is already sent. So they know what's going to happen. So what's happening, you're working way beforehand, you're giving them the information, you're trying to do well, so that when the life group leaders see that, they say, okay, hey, so even I'm expected to work in this way. And then you get it as a single task, meaning the only way you can make a cell ministry work is for it to become the single task of the church. Now again, this is when you want your cell group to be, your church to be completely cell groups. So no other meetings, no other events. And that's not something that we do. So as I mentioned, we do a lot of events, a lot of other conferences that we have. But thankfully, we're also able to build on the life group ministries. Look at some of our current programs. We have face to face for teens. I'm not sure of these are continuing now, especially these two, teens and 20s. So right now we have the teen church, so teens are being ministered to them. Face to face was more for, we have worship times. Covenant keepers was a ministry that we had, but we don't have it now. Then we have the biblical foundations course that we also have right now. So this is just a short list, but we have a lot of other ministries. I'm sure if you go to our website, you'll see all of them. But something that's really exciting is that as a church, we were able to build all the ministries. So that way, we're being fruitful in all areas. We're trying to not just focus on one area, we're trying to focus on different areas. So we're not just avoiding certain things or neglecting a certain aspect. We're doing our best to reach out to every category. So for example, in 23, the new ministries that we started was the life coaching ministry, the men's breakfast ministry, women's lunch here, and the single adults meet for different ministries. Now just because we're doing all this, doesn't mean that the life group ministry is going down. So luckily, we have leaders and volunteers, ministry leaders in each of these areas. So the leaders drive the entire ministry. Look at the essence of a cell church. Number one, relationships. It is the heart and life of the church. The cell is not a program. It is not a meeting. The cell is a lifestyle. Participation. Everyone is actively participating. Here again, ministry is not optional. Everyone must be willing to minister in some area or the other. And that is why we emphasize that if, for example, you've got a cell group with 25 or 30 people, I'm sure not all of them will get an opportunity to serve. So that's why we break it down. Another reason why we break it down to smaller units. So everyone get an opportunity to minister. Everyone should be leading others to Jesus, caring for others. Everyone should be ministering for one another. And then there's empowering. Leaders in growing churches concentrate on empowering other Christians for ministry. And so as a cell church, we empower people. We give them opportunities. We train people. We participate with them. We help them to lead. And many, many times, some of the things that have happened in our church is people have been part of our life groups. And they've been with us for many years. And eventually, they have gone out and started their own churches.  How can you go and start your own ministry? If God has called them, they've gone and started and they're doing well as leaders. We must be able to trust them, release them, let them do what God has called them. We have empowered them to become good leaders. And many times, we get these emails saying that I was part of life group and now I've started my own church. I've learned so much of life group. I missed the life groups or I missed the things that we did in the youth ministry. So remember that you're empowering people. The focus again is on Jesus. So it's not about the person. It's not about their work. It is Jesus doing the work through us. And leadership is given to Jesus. The Holy Spirit is allowed to work and minister to us. Then there is outreach and multiplication. We talked about this. As a cell church, we do what we have to do in terms of outreach, plan, strategize, evangelize. In networking, all cells, we may have 50 cell groups. Remember that a cell group is not independent, but is interdependent. Cells can work with each other. Just because a cell group is in, we may have a zone, the north zone and the south zone cell leaders coming together and doing something for the church. They may be in two different, maybe 50 miles apart in the same city, but they're coming together to do something. And what happens is it brings like-mindedness people understand that, hey, we're all part of the same vision of building people or doing ministry. And so networking together. So one of the things that we encourage is for life groups to come together. So sometimes what the youth girls life group, what they do is, I think it's once in two months, not really sure, once in two months, they come together. So two life groups come together and they meet and they just probably they spend time and worship or they spend time in extended time worship or just reading or whatever they feel like doing. This is a part of the life group. And we have family groups that meet from different places, they meet together and they go out on outreach, they go around, they've done this in December, they go out for Christmas programs and all of it. So networking within cell groups. And finally, adaptable structures. So the organization is here to serve you and not to bind you, meaning as a church, we don't want people to feel, oh, if I don't follow this structure, then maybe we put a task. No, we don't want people to feel that way. So how can I be adaptable? Over time, initially when we had life groups, I'll share this and that means so initially when we had life groups, we used to encourage everyone to meet every week. Because every week is when people get ministered to, there's this more fellowship happening. But over time, we understood that, okay, they may not be able to meet every week, why? Because people work Monday to Friday. So let's make it bi-weekly, meaning once in two weeks. So we give them a choice. See, so whenever I request or recognize leaders and they say, okay, first thing I say is, hey, this is what life groups are doing. Some of them meet every week, some of them meet bi-weekly. So you have the choice how you want to meet. So we've given them the choice, an adaptable structure, right? And let me also tell them, so as of now, we are, I mean, what we do is we are discussing the Sunday sermon. So how do I help with that? So if you go to the sermon notes at the board, we have questions. So you can use those questions to guide your discussions. We're making it adaptable. Now for the youth life groups, especially for the girls, what we do is we tell them, okay, you can meet bi-weekly or weekly. And then, so there are a couple of girls like what they do is they meet every week. But two weeks, they meet online. And alternate weeks, they meet in person, adaptable. Why do they meet online? Because they can't travel back every, they're young girls, right? They may not be able to travel back all the way wherever they are meeting. So two weeks online. And the other two weeks is they meet in person. So if you look at them, they're meeting every week, but they're meeting in a hybrid manner. And then same goes with the youth boys as well. Now we also have a few youth life groups which meet up at coffee days, adaptable. We keep it open for them to do it that way. But we always encourage them. It shouldn't be a time of just talking and, you know, spending time. It should be a kind of ministering to each other. A good discussion should happen. And that's the point of the life group. So we'll stop here. And on Friday, we'll look at chapter 11. We're going to chapter 11 and look at the chapter 12, the unlimited possibilities of the several groups. And after we complete these notes, what we'll do is we'll look at a few aspects on discipleship. What is the meaning of discipleship? What is the structure involved in discipleship? So we'll look at that as well. Any questions? Any thoughts? We close? Okay. All right. So have a good week ahead. I'll see you on Friday.


Hello everyone and welcome back to another video. In this video we're going to be using some of the knowledge we've learned in the previous videos and really sort of building on some actual real world beneficial macros or scripts shall we say. So we're now actually going to be using something that you'll probably find great benefit using in your day to day role. And that actual feature is going to be copying data from one workbook into another. And I guess being more specific obviously we're going to be writing this script into one of our workbooks and we're going to be obviously from that active or open workbook we're going to be opening a second workbook copying out some desired information and then pasting it into our sort of our open workbook. We're going to cover off a couple of different ways of doing this from the very basic of just literally copying the data and pasting it in. And also at the end of the video or towards the end of the video we'll be looking at how we can obviously make this a bit more technical and be able to say okay we want to copy some dynamic data so we need to go through that data and find out how many rows are within that data and then also in our file that we want to pull that data into being able to put that data into the next available row. So obviously that detail is going to be very beneficial if you've got data that's going to continue to grow and you want to add to the bottom of it. So obviously make sure you watch all the way through the video to pick up that more valuable information at the end there. So the first thing we need to just cover off we have looked at the previous video but I've just got a file or folder that I've created and in there I've put some sales data. So if we just open up the sales data file you can just see what's in there and it's literally just 10 well 11 rows in total but 10 actual rows of data and it's just some dummy sales data that I've put together. You'll see that I've color coordinated the countries that has real no bearing on the data at all it's just going to help me explain some features of the copy and paste as we go through this tutorial. So what we'll be doing and again while I've got this data on the screen is obviously will be automatically opening this file as I've just done manually copying out our desired data excluding the headers and then pasting it into our source file so this sales report we have here on the right. So we'll close the sales data file and we'll jump straight into it. So the first thing we'll do is the most basic of options and that's literally just doing a basic copy of a defined range that we'll put in and obviously to a defined area. So for that we're going to do a sub routine and we'll call this one basic copy and score paste and obviously I'll mention this again later in the video but the sort of code that I'm using here I will link to a file where you can download that Excel file to be more specific so if you're having any problems when you're typing this in you can obviously go and pick up that actual code that we're looking at here today. So the first thing we'll do is open our workbook. So for us it's going to be workbooks.open and we just now need to enter in here the file path for that workbook. So the easiest way to do this is obviously to find your file or the folder that your file sits within and for me you can see it's just sitting here so I'm just going to go into the navigation pane at the top here and you can see we've now got the full path for that file. Once it's all done I'm just going to copy that out and then paste it into these two quotations and then the last thing I need to do is if I just move my file over the side here so I can see is I just need to do another backslash and then type in here sales data and making sure I get the correct file extension excel sx so that we've got the complete path to this file. So this tells our VBA code or this tells our Excel that we need to open this workbook and this is the file path for that workbook to open. So once we've now done that the next part is fairly straightforward. We just now need to go workbooks and this is where we're now referencing the actual files we've got available to or the sheets we've got available in that workbook which is now opened and we want to go open sales data.xlsx so it knows what workbook we're referring to just one which now opened and we want to then go into sheets and we're going into the sales sheet so we're in that file you may have noticed that the sheet that the data was in was just the the sheet named sales. Now we can just go into dot range and let's do open here so we can now define the exact range we want to copy so for us it's going to just be quotations a to to g11 so this is the specific range that we want to copy copy and then we're going to do an underscore here and go underneath that code so what the underscore means is just a continuation of our code so we could write this just to the right-hand side but I'm just going to actually rather than complicate it what I'm going to do is I've got my copy there and all I now need to do after this space is the location in which I wish to paste that information so for us we can now use a new variable called this workbook so what this allows us to do is rather than refer to this file we currently have open of sales report we can simply put this workbook and what will happen in the script is we'll say okay the code we're now typing is contained within a certain workbook therefore that workbook is known as this workbook so nice and simple one there and a new little one we can use we're then going to do sheets open total sales I'll keep saying open but it's not actually open there's just obviously refer to total sales and then we want to just go dot range and go that a to enter and you can see it's formatted for us and the better way to do this is it was type that all the better way to do this but when we work with copy range dot copy once you do obviously a copy arrange the next part of the next very we need to enter is the destination so after the space you don't need the brackets around it but after hitting copy into space you just need to put them the destination path we want that data to go and that's exactly what we've done here a bit more detail so this first part here is obviously the range copy that you have below and then this next part here is the destination in which you want to paste that data once we've obviously pasted that data the last thing we would like to do is just now save or save and close this workbook that we just opened here called sales data so all we need to do then is go workbooks and refer to this workbook in particular so we've got sales data dot Excel sx so it's really crucial must always remember to get that correct file extension when you're referring to it dot close and another simple option we've able there and then lastly we're going to do another parameter we've got here is just going to do save changes no changes are going to be getting made to the file because all we're doing is copying from it but we just set that to true so that it just does a save when it closes so this is an entirety of the code we need and I could just expand this here just so you could see it ever so more so yeah all we're doing is opening the workbook we're then saying this is the static range you want to copy and this is the static range we want to paste to and obviously sales data close and save changes once we're finished so let's just reduce this window down ever so slightly so now if we run this code hitting f5 you wouldn't have seen that because it happened on the other screen but what happened is the file opened up on my screen it then obviously took this static range that we had here and it's pasted it into our excel file and obviously alternative afterwards is then just close that workbook as well so that's a tick and that is our basic copy and paste method completed so the next option when it comes to copy and paste is doing pretty much the same as we've just done there but this time actually pasting values so the benefit of doing this is as you saw in the last example where we copied across all different the color formatting of each row this time we just want to copy across the rule value so we don't want any of the cell formatting so to do that it's very much the same and just going to cheat here and I was going to copy the very this code we've got here first so let's go copy and this subroutine will call sub paste values just so we're not referring to and I can just paste that copied code into here and we are going to just remove this first or this middle line like so because obviously the first line of opening the workbook and the closing of the workbook is going to remain exactly the same it's only this bit in the middle that we need to change so the first part we're going to do and actually this part is going to be very much the same as well but we'll just type our game again just helps obviously repeating something helps make it become more familiar so we need to go workbooks and refer to our sales data dot xlsx and we want to go to sheets data well it's about with a d data dot range and we're going to go to a to and g11 that once again and once we've got that we need to do copy and in this time we can just go on to a new row and let's because our code is getting a bit bigger let's start commenting what we're doing here and in our previous videos you might have seen us do this if you're not familiar it's really simple to add comments to our code all we need to do is hit the uh i can't think what's cool but it's on the same key as the app button you just don't need to press shift and that allows you to do this uh this icon here this comment out and we're able to then obviously it'll put our text to green and this text we put in green won't be executed on our code so it'll be there as a comment you can see on the screen but as far as the script is concerned when it's running it won't it won't cause any problems so the first part here is open source workbook and you'll see it turn green as i click away now the second part here is we're going to do uh okay so we are um selecting or copying should i say copying our source uh sales data and then the third part we need to do now here is okay define define range um define destination and paste values okay so for this one again it's going to look very similar to that last one we're going to do workbooks or no we're not going to do workbooks we're going to do this workbook as we know it's a lot easier or not easier but it's a simpler way to refer to where we want this particular workbook we're working with this workbook sheets and it's called total sales and we want to go into dot range oh my spelling is gone all by yeah being navigating the keyboard has gone a bit all over place and we want to go to a2 again and this time we want to go dot paste special and again previous video you've probably seen us use paste special so this works exactly the same it's just obviously we're using them a bit more technical code should we say and paste special the last part i need to then define what that paste special is so you paste colon equals excel paste values and when we hit enter you can see that it's reformatted my text just so we know that it's actually accepted the information i've provided and this last bit as you know is going to be a close and so source workbook okay so this time we can now run this code and we'll see what happens i'm just going to hit f5 and there you go you can see that it's now obviously pasted our data into this obviously into the destination file the difference obviously we're using the paste values as as you can see none of the formatting in the cells have been copied over so we haven't got any of the obviously highlighted cells here i mean yeah highlight cells or rows should be more specific and you can even see with the formatting of the date and the sales total obviously that hasn't pulled across that formatting either so like i said working with paste values has its uses as does obviously copying or formatting as well but this is just to show you another way i've been able to do this using the paste value method it should use so required this last option that we're going to look at is the more complex and it's probably going to be the one that you will want to use the most especially if you're working with recurring reports where you might want to be pulling let me say monthly data into our total sales file over here and you want it to gradually build each month so obviously with each month you want this list to gradually grow rather than just being replaced as we've looked in this previous two examples because obviously if you run that code multiple times it would keep overwriting the same data that it already pulled whereas this option is going to allow you to find the next available row and add onto that data so we'll jump straight into the code there's going to be a few more bits that we need to define and obviously reference as we go through this so i'll try and go through it um obviously as slowly as i can and obviously referencing each part as we go but just to obviously remind you that you go into the links of this description or description for this video below you will find a link from which you can download this excel file i'm using here so obviously it'll give you everything you need to just copy the code uh if you do get stuck along the way so what we're going to do is get jump into it so we go sub and we'll call this copy sales underscore data and in we go so the first thing we need to do is we're going to start defining these worksheets rather than just writing the code each time so the first thing we need to do is go dim and we'll say dim worksheet copy so just ws being short for worksheet and we'll define this as a worksheet so this is the file that we're going to copy from uh we'll do destination now so we'll call this one ws desk as in worksheet destination and that's also as a worksheet a worksheet uh the next thing we need to do is we now need to find a couple of integers so these are going to help us to define the row it's so in this source file if i brought it across you can see it so we know that there's 11 rows of data in our source file so what we want this uh first integer integer to do is to say right how many rows of data is there so okay we can go down and say right there's 11 or if this grew and we had an initial one or two pieces of information we wanted to learn something say okay well we've now got 13 pieces of information so it will continually update for us and on the contrary obviously if there's less data it would again obviously it would identify that there was a lesser number of rows so to do that we first need to define these as integers so we're going to go dim and i'll call this one copy last row as integer and the last one we need to do again is for the destination so this time we want to go into our destination file and we want to identify what is the next available row so for us i mean as we look at the moment we can see there's information in row one which is the headers so we'd want our data to be pasted into row two if however there was some information down into row six and i've just copied country there just gives me a basic example we at this time want to paste into row seven because obviously there's already some existing data here we don't want to replace we want to go into row seven to obviously start collating that more information in addition to what we already have so what we need to do here is go dim and we'll call this one dest last row you can obviously call these whatever you want the integer seems the most logical as we're typing this out today and let's start commenting as well with what we're doing to help reference where we are in the code so the first thing we need to do is we need to open the workbook to copy from and in order to do that it's going to be exactly the same as what we've already looked at so it's going to be workbooks.open and in our quotations we're going to put our file path which i've just copied over to the side here and again i can't stress we need the importance of making sure you put the correct file extension here as well and also one more thing to stress because obviously the code if you source this file will be different if you just need to make sure that you go into wherever the file is stored and you literally go into this navigational here and you literally just copy this exactly as it is obviously adding the additional backslash with the file reference at the end there but obviously yours will be different to what mine is so just make sure you make that update if you do copy and use this file so i've got my sales data reference here the next thing i then need to do after that is it's going to be to is define each workbook and by that i just mean we're going to set to give each workbook a variable to use rather than have to keep typing this out so to do that we're going to do set ws copy equals to workbooks and it's going to be obviously sales data dot xlss xx sorry dot sheets and we want to pull from the sales data sheet within that workbook and you can see obviously it's done the formatting for us that's obviously always a great tick as i keep stressing to let you know that what your input is correct and the second one we want to do is set ws best equals this workbook and it's going to be dot sheets and it's going to be total sales and you can see there's an error there because i did a zero rather than a closed brackets so number three this time we now need to define last row in source data so we know how many rows or rows you want to source from this file so this we need to take this variable from the top here copy last row any copy and paste it there so this is going to equal and it's going to be ws copy because now we've set this variable in this row above we don't need to type all this information out we literally just need this variable ws copy ws copy dot sales and we want to go to ws copy because we now need to refer back to that again to do our rows dot count so they will perform a count of how many rows are in that sheet once we've done that we didn't need to just say okay we wanted to do that in row or column a sorry dot end excel up so once it goes to the end of that range or finds that last row in there we want it to go up round row rather than going down right or left and lastly we're just going to then confirm that we wanted to do it on the rows if that doesn't make too much sense to just there there is a dedicated video i've done on the channel so you can check that out in our vba playlist what is also linked below this video should you want to recap or to look at that in more detail once we've done that the next thing we need to do is define the next or the row that we wish to paste this copy information to that is located in our you know our destination file so for that we're going to do number four or the four thing we need to do here is we're going to go define the next empty row in destination sheet so for us again just to let you know that would be in this example here would be row number two because that's the next empty row that we have so for this we're going to go test last rows so destination last row equals it's going to be wsdest because again we don't need to do that again doing dot sales open brackets and then we've got wsdest again so we can we can do the count of the rows dot rows dot rows dot count and again this is going to be in column in column a so the first column we have dot end excel dot row so exactly the same as what we've done there but the problem not the problem but the the point to mention here is at the moment with this piece of or this line of code it's going to tell us row number one because it's going to what it basically does is it rather than it says what is the next empty row in here it's literally just saying go to the last row that has information in it and for this example in in our destination file obviously that's going to be row number one when it comes to our source data that's great we just want to go to the last row what's being obviously used in that file because that's as much data as we wish to pull but when it comes to our destination we don't want to pace into that last row we actually want to go to the next one so we just need to do a little addition here of plus one so what happens is because we define this as an integer this is going to return a number so obviously we'll return the number one and by adding that plus one obviously it's going to turn that increment that result into an additional one value so it will return the value of two so it allows to paste into this row so again hopefully i've not made that more complicated than it needs to be um for the purpose of this tutorial you don't need to know much more detail about how this works other than this is the piece of code that you need to use to be able to perform this copy and paste so last thing we need to do now or not the last thing but the next thing we need to do is go five so we now want to obviously copy that information across so we're going to go copy range and we're going to yeah so it's going to copy the range that we've selected here from our source file and it's going to go paste to destination so this will probably look like a familiar piece of code too as well so we need to go ws copy dot range and this is where we define the range we wish to copy so we know the first part is static so it's always going to start in column a and it's going to start on row two because we don't want to copy the head is we want to copy the first piece of actual data from that range and we want to go over to column g but that is as far as we go with static information the next thing we need to do is go and copy last row so what this does is this copy last row we know that a variable is going to get picked up in this um in this line of code here so it's going to find what is the last row that has data in it and it allows us to reference it here so we know it's row 11 so it's in essence going to format this all changes to number 11 so that we have a range of a2 to g11 if obviously we had more data and we were up to row 15 it would automatically update this to us for a2 to g15 so we don't need to make any manual adjustments to that all we then need to do is copy that range to dot copy hit space and you can see it now asks us to provide the destination so very simply it's now wstest dot range and we want to do it into column a and once again we're going to do a little and symbol and this time we're going to enter desk last row so it's now going to provide us what is this next available row available in which we want to paste to close brackets and that is the copy and paste now performed the very last one here is we're going to literally just now again do a close source file and save oh well the better way to word that is close and save source file so that we know what we're referring to here simply workbooks dot oh no sorry workbooks open brackets sales data dot excel sx close quotations dot close and in the last part here we've got the saves changes so we're going to put save changes and codon equals true hit enter and that is now all of our code so what's going to happen here is it's going to open our source workbook it's then going to set our variables so it'll define this variable of ws code as that workbook we've just opened and it's also going to do the same for this current work but we want to paste to the third part i was going to do is it will define what is the last row within our source file that has data in it so we know how many rows we wish to copy our destination last row is then going to define to us in our destination sheet what we have on the right here what how many rows we are using go to the next row so that we know we're going to be pasting always into the next empty row the last one the last part keep going the last part but point number five is then literally going to perform that copy for us this did not it's going to look at this dynamic range here based on how many rows we have in our source file and copy that range and it's then going to paste that copied range into again another dynamic row based on how many rows we have of information in this sheet on the right and then lastly i always keep like saying lastly it's then going to close that sales data file what is our source file and make sure any changes are saved and as we touched on earlier that aren't the changes that are going to be made to the file because all we're doing is copying the data out of it so at least this way i just make sure the workbook does to save any changes that have map made and that is the extent of the code so all we can do now is just run this code so i want to select within the sub and hit f5 and you can see it's now copied and pasted all that data across and we've done a simple copy and paste so you can see all the formatting has come across as well if you don't want this obviously with all the formatting that we have here obviously you can refer back to this second one we looked at the paste values and ensure that you're doing your paste as this with the paste special so that's an easy change to make should you wish to do so and as we can obviously see that everything has come across as desired the real benefit of doing this now is if i was to continuously run this book to hit f5 again you can see how it finds that next available row what was row 12 and now continually as the data or appends that data to the bottom of the existing data if i did it one last time so clicking on the sub and hitting f5 you can see the new data is once again added to the bottom so this is really really beneficial like i say if you have a scenario where you're wanting to source new information that is in that file and always add it to the bottom of this file so in future videos we'll look at some more it'll build upon this example to look at more technical examples such as sourcing from different files uh well to name just the one that comes to mind so we'll look at more stuff like this but hopefully this now gives you all some building blocks upon the previous videos we looked at to use some really beneficial code that you can start using and transforming the way that you use excel obviously excel being what it is we're always copying data from other files or trying to merge files into one and like i say this is a real beneficial way of using excel vba to automate that potentially timely process so this video was a bit longer than normal i hope you still managed to stay or stay interested i guess is the keyword here and make it to the end if you have please do give the video a like as it would be greatly appreciated by me as it does obviously take quite a bit of time to pull these bigger videos together and plan them out as well but obviously if you give it a like it would obviously also really help the youtube algorithm to make sure that more people can find this video and learn the techniques that were basically covered in it if you the first time you found the channel or you have watched previous videos of ours before and you've not yet subscribed to the channel please do consider subscribing to the channel and hitting that bell notification button it's also i'm gonna say it'd be really appreciated by me as it is very beneficial to the channel as well and obviously by hitting that bell notification button you'll be notified of all of our future videos as they come out so last things any questions do drop me a comment below this video and i'll get back to you as soon as i can and you've also got the links to this file that we've been using here in the description to this video as well so you can go download that for yourself if you're having any troubles or you just want to obviously use it to follow along at home thank you very much for watching and we'll see you in the next video


Hey everybody, I'm Steve at Blackstar. Welcome to May's webcast on home recording. Thank you for joining us this evening Just to let you know what gear we are going to be using tonight We've got one of our rather new lovely artist 30 combos here Which is a recent valve addition to our range of products and for recording wise We're going to be using the iPad and garage band, which is a one of the earliest platforms for home recording We've got a little focus right Interface here, which we'll be using and also we've got our beam base electric acoustic Music all in one box and also we've got our brand new ID core high-powered 150 combo here to use as well and I'm hoping to utilize some of the features of each throughout this small presentation But just to give you a bit of a background on the artist series There's two in the range. There's a 15 watt 1 by 12 and a 2 by 12 30 watt combo available at the moment two channels, but Typically you'd normally get a clean and a dirty channel on an amplifier But this time what black star I've done is really focused on building a product for the pedal Guitar player that likes using stomp boxes and so on so with this you've got two choices of clean Which is really really nice The first channel is very simple It's just a volume and a tone control and this more this is more of a kind of Class A kind of British style barking clean sound if you like Channel 2 it's a little bit more going on. You've got bass middle treble as well as gain and volume For that specific channel and black stars infinite shape feature the patent ISF at the end of the chain there Which is more of a class AB if you like more of an American style sound With a little bit more grit if you push the volume level And the gain and then we've got master reverb and master volume as well. So the nice thing about these products is that they Sound great for vintage guys blues and rock guys But if you just keep it clean and drive anything with high gain in the front it works really really well um For me at the moment we're just going directly in because i'm feeling the sands of the amplifier itself just direct It's sometimes nice just to plug your guitar direct into an amp and play around but because we've got a master volume on this You could easily use this at home for recording. So we're not particularly loud in here today but um This will absolutely blow the roof off most venues if you're if you're on stage with it But also for recording you can turn the master down and drive each channel Accordingly to the sound you're after Um, let me show you some sound bites. So this is the first channel, which is quite clean from the outset Even if we push the volume on that specific channel all the way up it's still really clean Really nice just a perfect platform for any pedal really Onto the second channel. I've got the gain roughly about one o'clock. So there's a little bit more grip there Um, but by no means is it high gain Just shoot back and forth so you can hear that difference again between the two channels If I drive the second channel you do get a bit more bite as we said But by no means is it's super high gain If I switch my guitar to humbuckers you do get a bit more grit, of course Let's go to the bridge. So we're really pushing it there full gain on second channel bridge humbucker A nice classic blues or rock tone there But you can imagine hopefully putting a boost pedal through the front end or a drive to give it a bit more amazing sound So, yeah, let's maybe um try and record something I've already got a preloaded drum track, which is a just a simple groove And the first thing i'm going to do really is a a nice rhythmic track Using the artist amp So let's see what we can come up with. I kind of like that lick I was doing previously We just some just some basic chords if you like So let's uh, let's see what we can come up with that sounds pretty good. So should we take a quick listen? Let's see how it sounds That sounds pretty good to me so far. Um, I think I mentioned this before but we're using a couple of monitors here just to Monitor what I'm doing is if you were at home with your own small studio monitors as well. So I'm happy with that. Let's maybe try and look at a bass line Okay, so you can see I've got a bass guitar with me now and I'm going through the black star beam Which is a a desktop amplifier for the home user really Um, and it's a really lovely bit of kit It's made from a really nice wooden cabinet each speaker inside is encased in its own wooden cabinet as well Which is ported each speaker, which is stereo, of course Um is tuned to the cab The whole ton of r&d went into this product to make it absolutely the best it can possibly be and It's a beam is an acronym if you're not already aware of that bass electric acoustic music It's a bluetooth speaker. It's a guitar amplifier with many many different Stars of sounds from clean to scream. There's a couple of acoustic simulators in there. There's two Two preamps for an acoustic electro acoustic guitar and two for a bass as well Um and you can use it for usb recording You can use it in conjunction with our insider software as well for Deeper editing and using the phrase trainer and all that stuff and sharing patches with people around the world um and most importantly it has black star super wide stereo which really Uh immerses you in like almost like playing in a stadium. The sound is bouncing around the room Almost like a three-dimensional sound for your effects like reverb and delay and so on Um, but I want to really show you just how good the bass side of things can be which is something we don't often focus on um So we have two bass voices one classic and one modern sound So at the moment, this is the first voicing which is more of a classic bass sound if you like The second voicing is more of a modern sound with more of a kind of click to it Um Quite a different sound there, but we're going to stick with the first one That's what i'm feeling for this specific track a bit more of a vintage blues style sound if you like Um, but there are some effects as well. Um, if you're used to the effects on the id section You'll know that the the first four segments are for reverb, but obviously Bass and reverb isn't Really a useful thing for it for most. Um, so we've put four styles of distortion in there Um, but the interesting thing is the segment becomes a blend control between a wet and a dry mix For your clean tone and your distorted tone, which sits underneath so you can get some really interesting sounds for example The the primary sound that you're here now is a very clean tone Very much a clean tone if I just add a distortion in which is just a small mix of it You can no doubt hear that undercurrent of overdrive which is Really useful for recording if the track suited it, you know, so you can almost get your Mini desktop black star b-man to sound like it's going through a huge eight by ten stack And rumbling and pushing and compressing Um, also we've got an envelope filtering there, which is a new effect for the modulations If you're into bootsie collins and funk music that's awesome to use But for now, we're just going to keep it dry and we're just going to play along with the chords I've put down and We'll see how it sounds Okay, so let's have a listen back to that and see if the levels are all good Sounds pretty good to me sounds good so far. Um, just to let you know while I was using the beam Um, we basically bypassed the focus right interface Um, and we're just going direct from the usb output of the beam Into a camera extension kit which is supplied by apple Um, and you can get these from apple store or online Um, and it allows me to have a usb to lightning connection for my ipad Simple, but we're we're demonstrating the possibilities of using the beam via usb to any any door So you can use it with anything like that you've got on your laptop and any any programs and so on so That sounds pretty good. Um To finish things off with some lead work or some melodies melodies over the top We're going to look a little closer at the brand new black star id core 150 combo here Okay, so now we're on to the brand new id core 150. Um, these amps are Brand new to black stars range. They were launched recently at the music messa show in frankfurt, germany and um so far so good everyone that's heard them has been absolutely raving about them Um, just to let you know a little bit of spec about the products There's two in the range both of which are using two by ten speakers and they're very very ultra light weight So these are ideal for the gigging musician in mind because id core the initial range of that Entry level combo style was basically a 10 watt 20 and a 40 watt So now we've done the high powered stuff because people were asking Oh, can I gig the 40 and to be honest with you that small range of combos was really built for home It's got full range speakers in there ideal for recording home practice listening back to audio Um, but these have got proper guitar speakers in there proper loud speakers So, um, we've kept that lightweight thing in mind So this is going to be really easy to carry back and forth to the gigs and practice rooms We've still got super wide stereo usb for recording and connectivity We've got an effects loop on there stereo effects loop Um, emulated stereo line out fully cue this time And all the great features that are typically part of id core In addition to that we've got a built-in looper with 30 second looping time So you can literally record something clean and then change a channel or a preset with your foot switch And you can get a nice lead sound over the top and when you record an overdub It doesn't take away that 30 seconds. It's still Infinite amount of overdubs with that 30 second period And lastly we've got a built-in octaver in there, which is a new thing for black star Again, that gives you a little bit more than just one sound There's a low or a high octave to choose from and you can mix between the two And have a little blend of two as well And also there's a wet and a dry mix between your original guitar signal and the octave So for example, you could have a little smidgen of the high octave With a minimal mix to make your clean guitar sound like a 12 string rickenbacker for that 60s kind of flower power vibe Or you can turn the octave really low And have a lot of mix so you can basically make your guitar sound like you're part of royal blood Or muse or something like that or jack white just some interesting Guys that use octave in an interesting way. So Lots of opportunities with this, but for now, I'm just going to put a couple more kind of tracks on this song The first one we're going to go for is more of a picking Clean sound which is something like this Just adding a bit more glue to the track before we play something which is Lead related lead guitar related. So, uh, let's see what we can do Let's have a listen back to that to see how it sounds and feels It's working for me. So, um Let's try another track and just to let you know as well. We're using the usb at Directly into the ipad as well similar to what we did with the beam Okay, so to finish things off. Um, I'm just going to do a lead guitar Track now to add to the song. Um, but I've set myself up a couple of presets Which I'm using with the floor controller to change So I've got I can go from my clean sound which we've just put down To a slightly semi-driven rhythmic tone For lead as well if it was a subtle blues style sound and then I've got a high gain at the end of it as well But also I can add with my control pedal I can add a delay in there as well, which will work midway through soloing maybe Which has got the super wide stereo on which sounds really really lovely. Um, so let's see what happens So let's see how that feels So as you can see that sounds pretty decent really and we've not tried to mix it or eq it really in any any detail Um, but by utilizing, you know Such powerful products like the artist series at lower volume at home um, the beam which is really a The central hub for the home guitar player and the brand new id core high powered 150 which again is really built for gigging but again, you can keep it really low for Recording at home and utilizing the usb and all the other features As always black star is trying to help you the guitar player at home Find the best tools you can so I hope this this has been a little bit educational for you. Um Any of you that are writers home recording? Hopefully it's been hopefully it's been helpful. So we'll see you very soon. Thanks for watching and I've been steve at black star. Cheers


God, it's better than the first one. That's not true! That's impossible! Ooh, that's a hot mug, guys! Hey guys, this is my review for Star Wars Episode 2 Attack of the Clones and one very little interesting tidbit to start off this review. The assistant director for this film was James McTeague, the guy who then went on to direct V for Vendetta and he hasn't really directed anything good since. Attack of the Clones takes place what like ten years after the Phantom Menace. Anakin has grown up into a walking Me Too movement poster child. Ewan McGregor has grown the Jesus of Perm and there is a very, very complicated, doesn't make sense when you think about it plot going on. At this point, we still don't know who Sidious is. However, his plans are starting to become more and more random because of his plan was to start this war in the first place. Everything he has done prior, up until the end of the film, makes no sense in the grand scheme. Why did he try to assassinate Senator Padme if he knew that he wanted Anakin to be heard?  How did Cipher Diaz set up this after them and 10 years ago? What was the point of the Trans Federation? He didn't just get killed, he didn't do anything else. Why did the Jedi take the jump again in the middle of his head? Why didn't he just get killed in the middle of his head? Where did the Duke of Sanctuary come out? He doesn't even make sense in the grand scheme of things. He was literally introduced because no one liked Jar Jar. There are a lot of issues with this film in terms of its narrative. However, the one very, very saving grace, it's not boring but for far, far different reasons. The acting in this is horrible. Natalie Portman's delivery is that of a block of wood. Hayden Christensen is that of a whining man child. Ewan McGregor, by God he's trying his best but the fact that he's on a green screen stage and he has really no direction whatsoever from George, he looks just as lost as you would feel in that situation. John Williams once again is absolutely killing it though with the score. The visuals of this film once they get going are fantastic. The final battle is still amazing to watch when that trade federation ship crashes and there's that huge dust cloud and they're like... I thought that was cool when it was a kid and I still think that's cool now. Speaking of things that I thought was cool when I was a kid, that Yoda fight with Dooku, that was really cool. It kind of breaks his illusion of the character. I'm not as butt hurt about it as a lot of people were. There were a lot of people who were very upset to see Yoda doing this. I can kind of understand their reasoning because if he's this old and he's moving around this slow, how can he all of a sudden jump around like a Cirque du Soleil gymnast? But also it's just the character of Yoda was meant to be that of why he's in like a battle meditator. However, this is kind of building up to the fight in the third film because thank God that he did that because if he had just all of a sudden had Yoda take on Sidious without any prior knowledge of his skills, that would have been really random. But the main crux of the film is the relationship between Padme and Anakin and it just... God! Every time they say a sentence to each other, something to do romantic wise is just like... their chemistry is just... it's not that great. Their dialogue and delivery is just terrible. There are some moments here and there like when Anakin goes full postal on a Tuscan Raider family and it's funny to think about it now but when I was a kid, I didn't really cue into the fact that he murdered women and children. So it's not really that much of a surprise when he just takes it a little bit further and kills some Jedi children, but they really had to double down on him doing it because he had already murdered an entire village. The character of Anakin Skywalker on paper is a very cool character, a character being corrupted by his emotions, being manipulated by outside forces, and not being reprimanded because his master had a affiliation similar to that of his in his past. However Obi-Wan was able to walk past it, he was able to move on from it. This is something that they bring up the Clone Wars show. That piece of information makes their relationship so much more important, but no, they have these member when we fell into that pit of Gundogs. That dialogue isn't useful for anything, but the background relationship information about Obi-Wan makes his reluctance to do anything about Padme and Anakin make so much more sense.  And in the end Attack of the Clones is a cringy movie, but it's an entertaining cringy movie.  I'm going to give episode 2 a 2 out of 7. That's my review for episode 2 guys, I hope you enjoyed. If you did leave a like and if you're interested in more, maybe subscribe. Now we're coming up on episode 3.  Thanks for watching the video. My name is Nits, and you might remember me from the animated cult classic TV show Undergrads. It's been a while, but I'm happy to say the click is finally getting back together in an all-new movie, thanks to a successful Kickstarter campaign. But we are still asking for your support. To see any and all updates about the upcoming Undergrads movie, be sure to check out and like the Bring Back Undergrads Facebook page. And with any luck, we'll see you guys soon.