And welcome back to another class, of course, about the complete introduction to the debate with Excel.
So in the past few classes, we learn pretty cool things.
So basically, as you can see here, we have created a macro that enables us the capacity of generating
this table right there.
So once again, it's pretty cool.
And right now it only requires us one click to be able to generate all this table.
Well, three clicks.
We can do it even in one click to be able to generate all of this table.
What I wanted to do, what I want to do today is pretty simple.
So basically, we're going to work on the exact same project.
So this project right here, we're going to recreate it.
But but but but we are going to add a really interesting feature.
So pretty simple.
Let's say we are here and basically what we want to do, we want to work with our Mac.
So pretty simple as always.
We're going to go here.
We got to run our step.
Number one, as you can see, we will have our numbers and names right here if we want our step number
two, same thing.
And if we are step number three, it's going to come there.
But there is one problem.
We can run all our macros.
But the the run simply here, let's say, for example, we want to run our table right there or right
there or right there.
Well, it's not really possible because we have used absolute references in the case of this table right
there.
So what I want to do in this class is teach you how to run your macros, whatever you want.
So basically, you can run them whatever you want on this table.
And you'll see it's pretty simple.
And what we can do with this is pretty cool.
So basically what we are going to use, we are going to use this little button that is just here, which
is using relative references.
So you'll see it's pretty cool.
So what I said what I just said is that you will be able to run all your macros anywhere you want on
this table.
So let's start.
Basically, what we are going to do today is the exact same project.
So we'll start with the first step, which would be writing down numbers and names.
So pretty simple.
This is exactly what we are going to do.
So first of all, we click on use relative references to be able to use relative references and then
we are going to record or macro.
So in this case, we are at the project number two and we are at the step number one.
One last thing, if you want to put a space right here, it's not going to work because it doesn't allow
you to do so.
So as you can see, it doesn't work.
So just put everything together and then you just click on, OK?
All right.
So right now we are recording our macro.
So first thing, we just put everything here together.
We merge the cells, we write the number and names, and that's it.
Then we can just stop the recording of or macros.
Right now we have our macro right here.
So basically, if we want to run it somewhere, so let's run it right here.
As you can see, it runs perfectly, so if we run it right there once again, it's perfect and that
works perfectly, which is pretty good.
Now we have one small problem.
It's that we didn't put it inside of a table, so we can just do it once again.
Pretty simple.
Just delete this one right here.
There we delete it and we'll do it again.
So pretty simple, we'll just use the relative reference we record or micro, we'll call it, as I said,
to step one and click on OK, and then we can recreate our macro.
So basically, we'll just select ourselves, will merge them together.
We'll write down numbers and names and that's it.
Then we can just stop recording.
So right now we have everything that we need.
We can test our macro to see if it works fine so we can see it works perfectly fine.
So everything works perfectly fine.
One less thing.
If you have an issue and let's say, for example, you are running your macro and that instead of running
at the right place, it runs somewhere right here or somewhere right here.
This means when you were recording your macro, you were clearing either on the enter button, either
you were playing around.
So basically, this could be a bug with what you have did.
So pretty simple.
The second step, as I said, will be writing or creating this table right here.
So instead of each here, we'll write down a number.
So here will have no one in here will have number two.
So pretty simple.
All right.
So let's just rewind our macro.
So we'll go in the developer tab and we will run our macro.
Right.
So everything is at its place.
So, as I said, the second step is recording or micro.
So we click on a record.
It's going to be project number two.
Step number two.
So pretty simple.
All right.
So right now we are going to record our macro.
So here will have a name.
I will have.
So first thing that we recording will be our name.
Then we are going to record number one.
So we're right.
Number one here.
And you will have no.
So right now, we have everything that we need.
Now, next thing will simply be putting everything together right here.
So here we go.
This way.
And then here we are going to add the some.
Here are the calculations.
So basically here will have this will write down the calculations, so this will be equal to the sum
of all this.
So all those numbers.
And same thing right here, some of all those numbers right there.
And finally, the last step, just putting.
I think some little things.
All right, great.
So right now we have everything that we need.
We can stop the recording.
So right now what we are going to do, we are just going to generate everything so pretty simple.
We are going to go here and trying to generate this second step so you can see the whole table have
been generated so we can do the same thing right there.
Once again, we ran it, as can see, everything is perfectly integrated, and if we generate that step
one, we can just generate it right here.
So as you can see here, we have our step one and our step two that are working perfectly.
All right.
So last thing that we want to do, pretty simple.
We want to create our step number three, that we are going to be able to generate also.
Just merge everything to delete it, delete it.
So here is our step number three.
All right.
So pretty simple right now.
What I'm going to do, instead of just creating this step number three, I'm going to recreate the whole
project.
So pretty simple right now.
What I'm going to do, as I said, creating the whole project and stacking it as one macro.
So this way you will be able to see that it's possible to put everything inside of one macro.
So if you want, we can do the exact same thing with me.
So pretty simple.
Let's start.
So we'll go right here.
So, as always, it's going to be our developer tab.
What we're going to do right now, we are going to record our macro some pretty simple project.
Number two will call it full.
And here we are going to create micro.
I forgot one little thing so you can see here I forgot to click on our user relative references.
So it will start again with our micro project to for.
Great, right now, what we are going to do, we are going to record our project.
So a first step, pretty simple as always, we select ourselves, we merge them and write down numbers
and names.
So once we have this, we come back here, we select our first case that will be name.
Then we'll have number one.
Then we'll have number two.
Then was like this, then here will have that some.
Here will have the sum of everything.
So this will be equal to the formula of the sum.
So, once again, the sum of all this.
So you're pretty much the same thing, so the sum of all this.
Finally, we're going to go to the second place right here.
Here will have the name.
So once again, name.
The number.
And right there, we're going to select all those cases, finally the some.
So right here, we'll have the some.
And here, some of our numbers, so we'll have the sell off of our numbers right there.
Great.
So right now we have our macro as a whole so we can stop recording and we can try to run our macro somewhere.
So we'll just delete this macro.
Delete everything that we have written right here, and we'll try to run our macro somewhere right there,
let's say, for example, run it here.
So pretty simple.
We come back here and we use our relative, our macros, and we can run our micro right here.
And then, as you can see, everything runs perfectly.
So next step is pretty simple.
It's just adding our numbers to test everything so we can copy the numbers that we have right here and
just adding add them.
So we forgot to add one thing to our macro, which is to copy everything from here.
So pretty simple, we can just add it manually.
But basically what you guys can do is simply copy and paste the same thing for the numbers.
So we forgot to add the operation, which is pretty simple, so he will do the same thing, so it will
be equal to this number plus this number.
So here we go.
All right, so right now I did it manually.
Once again, you can do it with a macro.
So let's think what's also possible to do, it's also possible to, for example, create a graph for
our macros.
Let's say, for example, I want to create a graph.
It's pretty simple.
I can just select the whole thing right here and just generate a graph with it, whatever I want.
So it's pretty much the same way for it to generate a graph.
So I'm going to go in developer.
So use relative reference record macros.
So I'll call it graph.
And OK, so pretty simple, what I'm going to do, I'm just going to click on insur select, my numbers
will select everything that I need to select and just click on the recommended chart.
Here I have my chart.
So here we go.
I have my chart that have been created.
So pretty simple.
Come back to my developers, stop recording, and normally everything should work fine.
So if I run my Gref micro.
Actually, oil from indico, so we have our chart right here that have been generated.
So as you can see, it works pretty fine.
All right.
So pretty simple.
So right now, what you guys have learned is pretty simple.
You guys right now know how to basically run your macros anywhere you want on your Excel chart.
Well, on your Excel workbook.
So let's say, for example, on this macro right here.
Right there.
So it's possible I can just go on my developer tab, choose the macro that I want to run.
So in this case, project to full, I can run it right here and it has run there.
I can do the exact same thing right here.
So I select my micro project to full and works perfectly.
So right now I just need to add the numbers.
And basically one problem that we forgot to do is simply adding the calculations right there.
But besides of that, it's not that much of a big deal.
So right now, what you guys have learned, you have learned how to use the relative reference with
your macros.
So you'll see right now it's pretty cool.
So we are still in the creation?
Well, in the macro creation part of this course.
So that's it for us guys.
And see our next class.