Any possible VBA code to double and sequentially number names in excel? [on hold]
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
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.
add a comment |
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
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 isDo While q < LastRow Do Stuff q=q+1 Loop
(Except for your example I'm pretty sure you will wantq=q+2
– Emily Alden
yesterday
add a comment |
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
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
microsoft-excel microsoft-excel-2010 vba microsoft-excel-2007
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.
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 isDo While q < LastRow Do Stuff q=q+1 Loop
(Except for your example I'm pretty sure you will wantq=q+2
– Emily Alden
yesterday
add a comment |
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 isDo While q < LastRow Do Stuff q=q+1 Loop
(Except for your example I'm pretty sure you will wantq=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
add a comment |
0
active
oldest
votes
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
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 wantq=q+2
– Emily Alden
yesterday