PDA

View Full Version : loop that add lines alternately



eran3185
05-07-2007, 11:06 PM
hey again.
i have a list that contain almost 300 lines of countrys (the "red") and almost 1000 lines of cities (the "blue")
i want to typesetter like in column e-f
who has an idea ??

lynnnow
05-08-2007, 01:03 AM
Hey Eran,

If you could be a little more specific in what you are trying to do, it would help resolve your query.

Lynnnow

eran3185
05-08-2007, 02:19 AM
hey
like its seem in the attached file : i want that the "blue" will be under the "red" like u can see in column e-f

lynnnow
05-08-2007, 02:23 AM
Hey eran,

Looking at your provided example, you will need some kind of index to sort out which city belongs to which country. If you can get that done and post back a solution can be provided.

Lynnnow

eran3185
05-08-2007, 02:42 AM
there is 3 cities and 300 countries.
every country has 3 cities
i need a loop to do this thing

Charlize
05-08-2007, 05:03 AM
How does the starting sheet look like ? column A only countrys, column B only cities. Every country has exactly 3 cities ?

Charlize

eran3185
05-08-2007, 06:02 AM
yes
it's a simple loop

eran3185
05-09-2007, 02:56 AM
anybody ???