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
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
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
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
New contributor
edited yesterday
DavidPostill♦
103k25224258
103k25224258
New contributor
asked yesterday
Austin Roberts
1
1
New contributor
New contributor
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