Fill based criteria

Hi.

How to get the expected result by filling the squares with numbers in "Filled by Result" guide?

I have tab "Criteria" i need arrive o result equal Tab "Result" after...

Fill squares using filed "Number" in tab "Result" inside tab "Filled by Result"

Hi, marreco,

I canīt make a clue on how to handle your attachment, some explanations on the logic of how to find what in which sheet and fill in where would be welcome for my part.

Ciao,
Holger

hi Holger
Sorry, my english is very poor, I'll try to explain.

Considering only the tab "Criteria" and "Result"
I need to create a kind of order between the Area (41 ..... 30) and End (28 ... 18)
the code should get Are and first End paste in tab "Result"
Area End
41 28
37 28
31 28
27 28
42 28
38 28
32 28
28 28
43 28
39 28
33 28
29 28
44 28
40 28
34 28
30 28
after doing this, need get Area and second End, paste below (first action).
Area End
41 28
37 28
31 28
27 28
42 28
38 28
32 28
28 28
43 28
39 28
33 28
29 28
44 28
40 28
34 28
30 28
41 19
37 19
31 19
27 19
42 19
38 19
32 19
28 19
43 19
39 19
33 19
29 19
44 19
40 19
34 19
30 19
and so on
Thank you!!

hi fredlo2010, very nice!

so i need next and last part to solve my post.

considering the guide, "Position (Area - End)"

I added this guide, so you can see how the "End" are positioned.

I need to insert the C "number" column, squares within the tab "Filled by Result"

My idea is to do all this within a single code !!!

See my attached and will understand

Thank you !!!!

Hi.

display erro

run time error 438
object doesn't support this property or method

this line yellow

Please Login or Register  to view this content.

Hi fredlo2010 , it works very well!!

Thank you!!