Need help with VBA

M

mccdgxch

New Member
Joined
Jun 20, 2010
Messages
29
Office Version
  1. 365
Platform
  1. Windows
Hi,
I have a spreadsheet that really need your help. Please see the excel spreadsheet below. The above spreadsheet is format I originally had and the spreadsheet below that is what I wanted it to be. Is there a way that you can help me accomplish it using VBA?
Thank you and have a good day.

ActionLabelNumberRelationshipDetails
ReviseTY10A4793669
ReviseTY10B80544557
ReviseTY10C3221972
ReviseTY10D6018855347
ReviseTY10E18878773
ReviseTY10F145600
ReviseTY10G5473895
ReviseTY10H1482812
ReviseTY10I544579
ReviseTY10J824960
ReviseTY10K703221983
ReviseTY10L5755449
YMMMake=Toyota|Model=Corolla|Year=2008
YMMMake=Toyota|Model=Corolla|Year=2008

and I would like it to be like this below

ActionLabelNumberRelationshipDetails
ReviseTY10A4793669
YMMMake=Toyota|Model=Corolla|Year=2008
YMMMake=Toyota|Model=Corolla|Year=2008
ReviseTY10B80544557
YMMMake=Toyota|Model=Corolla|Year=2008
YMMMake=Toyota|Model=Corolla|Year=2008
ReviseTY10C3221972
YMMMake=Toyota|Model=Corolla|Year=2008
YMMMake=Toyota|Model=Corolla|Year=2008
ReviseTY10D6018855347
YMMMake=Toyota|Model=Corolla|Year=2008
YMMMake=Toyota|Model=Corolla|Year=2008
ReviseTY10E18878773
YMMMake=Toyota|Model=Corolla|Year=2008
YMMMake=Toyota|Model=Corolla|Year=2008
ReviseTY10F145600
YMMMake=Toyota|Model=Corolla|Year=2008
YMMMake=Toyota|Model=Corolla|Year=2008
ReviseTY10G5473895
YMMMake=Toyota|Model=Corolla|Year=2008
YMMMake=Toyota|Model=Corolla|Year=2008
ReviseTY10H1482812
YMMMake=Toyota|Model=Corolla|Year=2008
YMMMake=Toyota|Model=Corolla|Year=2008
ReviseTY10I544579
YMMMake=Toyota|Model=Corolla|Year=2008
YMMMake=Toyota|Model=Corolla|Year=2008
ReviseTY10J824960
YMMMake=Toyota|Model=Corolla|Year=2008
YMMMake=Toyota|Model=Corolla|Year=2008
ReviseTY10K703221983
YMMMake=Toyota|Model=Corolla|Year=2008
YMMMake=Toyota|Model=Corolla|Year=2008
ReviseTY10L5755449
YMMMake=Toyota|Model=Corolla|Year=2008
YMMMake=Toyota|Model=Corolla|Year=2008
 
Sort by date Sort by votes
Thank you so much my friend for your help. It works like a charm.
Have a wonderful weekend.
 
Upvote 0

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.
You must log in or register to reply here.

Similar threads

J
  • Solved
Using IF, AND, OR formula
Replies
5
Views
115
dreid1011
dreid1011
A
  • Solved
Comparing two excel files for matching / mismatching rows (long text strings - match() wont work
Replies
4
Views
576
ahaye
A
T
  • Question
Pop Up Message if specific cells are greater than other specific cells
Replies
5
Views
433
tabs1063
T
M
  • Question
Find & Replace Text for Hidden Tabs
Replies
7
Views
93
igold
igold
B
  • Question
Sheetname 'problem' and another Index-match problem
Replies
2
Views
510
Blackov
B

Forum statistics

Threads
1,215,333
Messages
6,124,317
Members
449,153
Latest member
JazzSingerNL

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top