View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gabriel[_3_] Gabriel[_3_] is offline
external usenet poster
 
Posts: 17
Default excel for each ..next

Hi,

I have the following table (in reality it is quite large) in an excel
wksheet:

1 1 1
2
2 1
2
2 1
2 1
2
3

I want to write a procedure such as I could obtain in another wksheet
the following result:

1_1_1
1_1_2
1_2_1
1_2_2 and so forth. There is a pattern here. Is there is a way to set
up a procedure to take advantage of this pattern? Does anyone has a
hint?

Thank you in advance
Gabriel