Complicated (split number then produce table and copy the data in a certain assortment)

[kradman]

I have a lot of number to deal with, for example:

if E2= 8815 so i should split it as following D2=881,C2=88 and B2=8(i used D2=MID(E2,1,(LEN(E2)-1) and it worked) then i've to create the below:
B3=0,B4=1,B5=2,.......9
C3=80,C4=81...........89
D3=880,D4=881,.......889

after that i want copy the table data from sheet1 to RES sheet as shown in the attached

can you help me guys??

[bentleybob]

Getting the information in columns B, C and D is easy as you suggest. But can you explain the logic for translating the data on Sheet1 to the table in RES?

[kradman]

The green cells on sheet1 are the keys as following:

- Start from the left and copy all the cells that their contents is smaller than the content of the green cell
for example 88 is the header of column C so I want to copy 80,81,..87 then move to the next column which its header is 881 and copy 880 and so on.
- Once I copy the last column which its header is 8815, I want to start from that column and copy all the cells that their contents are greater than the content of the header (copy 8816,8817....8819) then move to the previous column (Its header is 881) and copy 882,883,.....,889 after that move to the last column which its header is 88 and copy just 89.

I hope it's clear.