join fields

[Frank Kabel]

Hi
how do you want to display your 20*50*75 combinations (in a separate
sheet?)

 

[Frank Kabel]

Hi
two points:
1. PLEASE change your systme clock. Or do you want to be on top of the
list
2. Still not defined where the output should happen. But try the
following (adapt to your needs)

sub foo()
dim arow as long
dim brow as long
dim crow as long
dim trow as long
dim tcol as integer
dim res

tcol=4
trow=1
application.screenupdating=false
with activesheet
for arow=1 to 20
for brow=1 to 50
for crow=1 to 75
res=.cells(1,arow).value & .cells(2,brow).value &
..cells(3,crow).value
cells(trow,tcol).value=res
if trow < 65536 then
trow = trow+1
else
trow=1
tcol=tcol+1
end if
next
next
next
end with
application.screenupdating=true
end sub

 

[kumar]

Columns
A B C
AA 30A 20
BB 32C 21
AA 40X 22

A has 20 lines,
B 50
C 75
how to get all combinations by macro

pls advise

 

[kumar]

No in the same sheet, but first item in column in A has to combine with
each item in Col B and Col C all combinations; then second item in column A
starts to combine with first in B & C and runs through then the third in
column in A starts with the first in B & C and so on.
Thanks