finnstone
asked on
permutations of two columns of data into one column
I am trying to create a combination of columns data.
in book 1, i have 2000 company names. in book 2, i have 150 titles.
i want to combine these two books so that for each company name in col A, there are 150 rows with each title in one of them.
end reslt will be the permutations of 2000*150
example
book 1
AgentsX
Ain't Life Grand Investments
Aire Serv Heating and Air Conditioning®
Aire Serv UK
book2
CEO
founder
Director
book3
cola colb
AgentsX CEO
AgentsX Founder
AgentsX Director
in book 1, i have 2000 company names. in book 2, i have 150 titles.
i want to combine these two books so that for each company name in col A, there are 150 rows with each title in one of them.
end reslt will be the permutations of 2000*150
example
book 1
AgentsX
Ain't Life Grand Investments
Aire Serv Heating and Air Conditioning®
Aire Serv UK
book2
CEO
founder
Director
book3
cola colb
AgentsX CEO
AgentsX Founder
AgentsX Director
ASKER
it says variable not defined
Sorry about that. Change
Dim wsComp As Worksheet
to
Dim wsComps As Worksheet
Dim wsComp As Worksheet
to
Dim wsComps As Worksheet
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
awesome
You’re welcome and I’m glad I was able to help.
If you expand the “Full Biography” section of my profile you’ll find links to some articles I’ve written that may interest you.
Marty - Microsoft MVP 2009 to 2017
Experts Exchange Most Valuable Expert (MVE) 2015, 2017
Experts Exchange Top Expert Visual Basic Classic 2012 to 2017
Experts Exchange Top Expert VBA (current)
If you expand the “Full Biography” section of my profile you’ll find links to some articles I’ve written that may interest you.
Marty - Microsoft MVP 2009 to 2017
Experts Exchange Most Valuable Expert (MVE) 2015, 2017
Experts Exchange Top Expert Visual Basic Classic 2012 to 2017
Experts Exchange Top Expert VBA (current)
29100518.xlsm