# populate some cells after data verification

I have data in cel B7  IF IS TRUE I NEED POPULATE THE ADJACENTS  CELL  WITH A LIST OF VALUE

LIKE THE EXAMPLE HERE

HOW CAN I DO THAT ?

Book2.xlsx
Shums Faruk

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),",",""))``
Change the number 1*255 to 2*255 for D7, 3*255 for E7 and so on.

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.

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?

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
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

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.
Shums Faruk

membership
Create an account to see this answer
Signing up is free. No credit card required.