populate some cells after data verification

What is the logic behind these numbers? "01,29,79,09,99,19,69,44,49,41,46,66"

With what you are comparing B7 to be true?

LIKE I SAY GOOD FRIEND
 IF B7 = 01  I NEED THEM POPULATE THE C7, D7, E7, F7, ECT..
WITH THE NUMBERS
"01,29,79,09,99,19,69,44,49,41,46,66"

IF TRUE I NEED PUT 01 IN C7, 29 IN D7, 79 IN E7 ECT...

IF THAT POSIBLE ?

Copy paste your string "01,29,79,09,99,19,69,44,49,41,46,66" in O7, then in C7 paste below formula:

=IF($B7="01",SUBSTITUTE(MID(SUBSTITUTE("," & $O7&REPT(" ",6),",",REPT(",",255)),1*255,255),",",""))

Select allOpen in new window

Change the number 1*255 to 2*255 for D7, 3*255 for E7 and so on.

Please find attached for your reference.

Hope this helps
Book2_v1.xlsx

NOT REALLY!
WHAT I NEED IS
WHEN 01 APPEAR IN THE LIST OF NUMBERS
POPULATE AUTOMATIC THE ADJACENTES  CELLS WITH THE VALUES
"01,29,79,09,99,19,69,44,49,41,46,66" BUT EACH VALUE SHOUD GO IN AN CELL
01 IN C7 , 29 IN D7 ECTT

BUT IF 01 APPEAR IN OTHER POTISION SAY C20
THAT SHOULD BE THE SAME  01 IN D20, 29 IN E20 ECT..

MY CORRECTION IF 01 APPEAR IN B20

Wherever you have 01 in B Column, you need to have those numbers in O column as well.

Please find attached.
Book2_v2.xlsx

YES !

BUT THE EXAMPLE YOU SEND ME IS NOT WHAT I NEED BECAUSE
DUPLICATE THE DATA

Then please send me with every examples what you need?

WELL I SEND ALREADY
IF A HAVE AN LIST OF NUMBERS AND 01 APPEAR I NEED THE  NUMEBRS
"01,29,79,09,99,19,69,44,49,41,46,66" BE POSTED IN THE NEXT CELLS BUT
EACH NUMBER AN BY CELL  IN THE ADJACENTS CELLS TO WHERE 01 APPEAR

EACH NUMBERS IN AN CELL  EXAMPLE
01 IS IN B20 , 01 IN C20, 29 IN D20, 79 IN E29 ECT..

This is the same result you are getting splitting the numbers in each adjacent cell, where 01 appears in B Column.

NO IS NOT

IS ANY WAY
WHEN 01 APPEAR TO POPULATE THE CELLS
BUT NOT DUPLICATE THE SAME  DATA ???

Check again,

If B20 has 01, then all adjacent columns has split strings in same rows. See below columns & row number. Which does what you asked for:

I MEAN
THAT WHY I WRITE THE IF STATEMENTE BUT
I DON'T KNOW HOW MAKE POPULATE  THE CELLS

=IF(b7=1, "01,29,79,09,99,19,69,44,49,41,46,66"," ")
WITH THIS DATA

IF TRUE  what i want is ti populate the cells with this data but each number in separete cell

sorry for my caps ons

It wont duplicate the data, if you have another set of numbers for 01, then paste those numbers in Column O. It wont be duplicate.
Check below image:

thats is what i dont want to do paste
i need be automatic

every time 01 appear automatic popukate the cells

populate

OK please find attached...
Book2_v3.xlsx

is not good

Apology, I cannot help further.

if simple but i don't know hpw to do

if a have an lists of numbers
and 01 appear i need automatic populate the adajacents cells
with  "01,29,79,09,99,19,69,44,49,41,46,66" have to be in separeta cell each number

i can not have those numebres in the first row

don't know if have to be doing with visaul basic
but i don't know how to do

Please find attached last try with formula:
Book2_v4.xlsx

not working sorry

is any way that i can write an statement
with visual basic ??
for that situation??

I am busy with. Just hold on

Please find attached....Click on update columns
Book2_v5.xlsm

sure take your time

my list number

02
58
53
87
96
01 then i need populate with the "01,29,79,09,99,19,69,44,49,41,46,66" the cell in the same row
but i can have other number
lets say
28  then 28 have some data 20,33,47,89,57,55,


that reason i can do like you say
but for now i need 01

i can't do like you say because other data will be there

Good luck

is interesting but how i can edit if  i need??

you answer don't work for my

It will work. Just give me all the relative numbers for all lookup numbers. You provided just one example of 01, for which macro and formula both works.
I would want you to provide me expected result typed manually in your sheet.

GREAT JOB ! SHUMS  !!
JUST ONE QUESTION !
CAN I SEE THE CODE BEHIND ??

Navigate to Developer/VisualBasic and you can see the code

GREAT JOB !

You're welcome Adriana! Glad it eventually worked for you. :)