Any possible VBA code to double and sequentially number names in excel? [on hold]












0














Is there any possible way to take a list of items or names, such as:



Apples
Oranges
Grapes
Watermelons


And have excel double that information and sequentially number it, like this:



Apples1
Apples2
Oranges1
Oranges2
Grapes1
Grapes2
Watermelons1
Watermelons2


I know a little bit of VBA but I can't wrap my head around how I would even start this.










share|improve this question









New contributor




Austin Roberts is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.











put on hold as too broad by DavidPostill yesterday


Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.















  • Welcome to Super User! Please note that superuser.com is not a free script/code writing service. If you tell us what you have tried so far (include the scripts/code you are already using) and where you are stuck then we can try to help with specific problems. You should also read How do I ask a good question?.
    – DavidPostill
    yesterday










  • A basic loop should work for this, the basic syntax is Do While q < LastRow Do Stuff q=q+1 Loop (Except for your example I'm pretty sure you will want q=q+2
    – Emily Alden
    yesterday
















0














Is there any possible way to take a list of items or names, such as:



Apples
Oranges
Grapes
Watermelons


And have excel double that information and sequentially number it, like this:



Apples1
Apples2
Oranges1
Oranges2
Grapes1
Grapes2
Watermelons1
Watermelons2


I know a little bit of VBA but I can't wrap my head around how I would even start this.










share|improve this question









New contributor




Austin Roberts is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.











put on hold as too broad by DavidPostill yesterday


Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.















  • Welcome to Super User! Please note that superuser.com is not a free script/code writing service. If you tell us what you have tried so far (include the scripts/code you are already using) and where you are stuck then we can try to help with specific problems. You should also read How do I ask a good question?.
    – DavidPostill
    yesterday










  • A basic loop should work for this, the basic syntax is Do While q < LastRow Do Stuff q=q+1 Loop (Except for your example I'm pretty sure you will want q=q+2
    – Emily Alden
    yesterday














0












0








0







Is there any possible way to take a list of items or names, such as:



Apples
Oranges
Grapes
Watermelons


And have excel double that information and sequentially number it, like this:



Apples1
Apples2
Oranges1
Oranges2
Grapes1
Grapes2
Watermelons1
Watermelons2


I know a little bit of VBA but I can't wrap my head around how I would even start this.










share|improve this question









New contributor




Austin Roberts is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.











Is there any possible way to take a list of items or names, such as:



Apples
Oranges
Grapes
Watermelons


And have excel double that information and sequentially number it, like this:



Apples1
Apples2
Oranges1
Oranges2
Grapes1
Grapes2
Watermelons1
Watermelons2


I know a little bit of VBA but I can't wrap my head around how I would even start this.







microsoft-excel microsoft-excel-2010 vba microsoft-excel-2007






share|improve this question









New contributor




Austin Roberts is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.











share|improve this question









New contributor




Austin Roberts is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.









share|improve this question




share|improve this question








edited yesterday









DavidPostill

103k25224258




103k25224258






New contributor




Austin Roberts is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.









asked yesterday









Austin Roberts

1




1




New contributor




Austin Roberts is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.





New contributor





Austin Roberts is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.






Austin Roberts is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.




put on hold as too broad by DavidPostill yesterday


Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.






put on hold as too broad by DavidPostill yesterday


Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.














  • Welcome to Super User! Please note that superuser.com is not a free script/code writing service. If you tell us what you have tried so far (include the scripts/code you are already using) and where you are stuck then we can try to help with specific problems. You should also read How do I ask a good question?.
    – DavidPostill
    yesterday










  • A basic loop should work for this, the basic syntax is Do While q < LastRow Do Stuff q=q+1 Loop (Except for your example I'm pretty sure you will want q=q+2
    – Emily Alden
    yesterday


















  • Welcome to Super User! Please note that superuser.com is not a free script/code writing service. If you tell us what you have tried so far (include the scripts/code you are already using) and where you are stuck then we can try to help with specific problems. You should also read How do I ask a good question?.
    – DavidPostill
    yesterday










  • A basic loop should work for this, the basic syntax is Do While q < LastRow Do Stuff q=q+1 Loop (Except for your example I'm pretty sure you will want q=q+2
    – Emily Alden
    yesterday
















Welcome to Super User! Please note that superuser.com is not a free script/code writing service. If you tell us what you have tried so far (include the scripts/code you are already using) and where you are stuck then we can try to help with specific problems. You should also read How do I ask a good question?.
– DavidPostill
yesterday




Welcome to Super User! Please note that superuser.com is not a free script/code writing service. If you tell us what you have tried so far (include the scripts/code you are already using) and where you are stuck then we can try to help with specific problems. You should also read How do I ask a good question?.
– DavidPostill
yesterday












A basic loop should work for this, the basic syntax is Do While q < LastRow Do Stuff q=q+1 Loop (Except for your example I'm pretty sure you will want q=q+2
– Emily Alden
yesterday




A basic loop should work for this, the basic syntax is Do While q < LastRow Do Stuff q=q+1 Loop (Except for your example I'm pretty sure you will want q=q+2
– Emily Alden
yesterday










0






active

oldest

votes

















0






active

oldest

votes








0






active

oldest

votes









active

oldest

votes






active

oldest

votes

Popular posts from this blog

How to make a Squid Proxy server?

Is this a new Fibonacci Identity?

19世紀