Hello there
So here is the case. I have a column "Name" in Sheet1 for example:
Name
-----
Nanas
Sam
Nora
And then i want to copy the data in the column "Name" and transfer it into Sheet2 that will look like this:
Name
-----
AAA
Nanas
AAA
Sam
AAA
Nora
Can you guys help me on how to create a macro code that will generate an output in the example above?
Thank you.
Bookmarks